Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Data by current month

Hey,   I dont know what exactly this is called. But i have a command called inmonth(DATE, Today(), -1) as Flag in QlikView to calculate todays date -1 stored in Flag. However, when i calculate the ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Try a the below measure :

 

Measure 3 = EOMONTH(TODAY(),-1)

 

Thanks

Raj

Anonymous's avatar
Anonymous
Not applicable
8 years ago

What does Movement[Date] represent? and is MONTH the present month?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I had edited the post, pls check again.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thank You. But I think I explained the concept wrong, though the answer is right for that i had explained.

       

      Syntax:

      InMonths(n_months, timestamp, base_date, period_no [, first_month_of_year])

       

      For example:

       inmonths(4, '25/11/2012', '01/02/2013', -1 .  Returns True. Because the value of period_no, -1, shifts the search period back one period of four months (the value of n-months), which makes the search period 01/09/2012 to 31/12/2012.