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

Hi Anonymous

 

Please use TODAY()-1 in measure.

 

If this is the answer you are looking for , then mark the solution as accepted ( Same for your other posts as well, i have responded for couple of qns, but still they are open though they are answered).

 

Thanks

Raj

 

 

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 oj July 31, excluding August. Similarly if we were in September, it needs to show all values as of August 31

  • 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

      Hey, 

       

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