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
    8 years ago

    Try a the below measure :

     

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

     

    Thanks

    Raj

  • Anonymous's avatar
    Anonymous
    8 years ago

    Hey, 

     

    I think this may work. Will try and get back. ThankYou!

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.