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

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

        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. 

         

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hey, 

     

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