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

Can you pick up a  sample date for this formula and explain what otput you need?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

So since we are in August month, I would want my to show those values as of July 31, excluding August. Similarly if we were in September, it needs to show all values as of August 31. At the beginning of each month, the flag value shows the values as of the end of the previous month.