topic Re: Re: Need expression for previous month in QlikView

Need expression for previous month

Thu, 27 Mar 2014 06:52:55 GMT

Hi all,

I need to show previous month amount on selecting the current month PFA

Re: Need expression for previous month

tresB — Thu, 27 Mar 2014 07:01:42 GMT

Your month field is empty. Correct the date format, and reload to get month properly, and re-upload sample qvw.

Re: Re: Need expression for previous month

Thu, 27 Mar 2014 07:04:17 GMT

Hi Tresesco

PFA

Re: Need expression for previous month

PrashantSangle — Thu, 27 Mar 2014 07:15:42 GMT

Hi,

I go through your data,

You have many date for similar month,

So you want sale for same month date of previous month ??

or complete sale of previous month?

Regards,

Re: Need expression for previous month

Thu, 27 Mar 2014 07:19:42 GMT

Hi Max,

Here my date field is 'pstng date'. i need to show complete sale of previous month

Re: Re: Need expression for previous month

tresB — Thu, 27 Mar 2014 07:45:19 GMT

See the attached sample.

Expression:

Sum({<month= , [Pstng Date]={">=$(= MonthStart(Addmonths(Max([Pstng Date]),-1)))<=$(= MonthEnd(Addmonths(Max([Pstng Date]),-1)))"}>}Amount)

Re: Need expression for previous month

lironbaram — Thu, 27 Mar 2014 07:52:31 GMT

hi see attach example

you have to text boxes

1. current selection amount

2 . previous month amount

Re: Need expression for previous month

Thu, 27 Mar 2014 09:40:08 GMT

Hi Liron/tresesco,

If you don't mine can you please explain the expression bco'z i don't get the use of add months over there

Thanks & Regards,

Nagaraj

Re: Need expression for previous month

tresB — Thu, 27 Mar 2014 09:49:56 GMT

Addmonths(Max([Pstng Date]),-1) ---- this takes you -1 month ahead, i.e. one month backward from the maximum date of [Psttng Date] possible.

MonthStart(Addmonths(Max([Pstng Date]),-1)) ---- further works on that one month earlier date. MonthStart() gives the starting date of that date which is one month earlier, effectively, it gives you the first date of the earlier month.

Re: Need expression for previous month

Thu, 27 Mar 2014 09:54:49 GMT

Thank'z for your response tresesco.., but wen i tried the expression by removing add months .. it's working fine

Re: Need expression for previous month

tresB — Thu, 27 Mar 2014 09:59:52 GMT

Result should not be same there. You should recheck it with various selections