topic Re: month year in QlikView

month year

upaliwije — Tue, 04 Jun 2019 04:50:51 GMT

Hi Friends

I have following Month_Year field in QV pivot table

Month_Year

Apr-2019

Feb-2019

Mar-2019

May-2019

I want to make a calculation in my expression. I have written below one

SUM({<num(Month_Year)={"<=$(=MAX(num(Month_Year)))"}>}PROV_AMOUNT)

But It does not work. Kindly help me to correct it

Re: month year

Shubham_Deshmukh — Tue, 04 Jun 2019 05:53:10 GMT

Hey @upaliwije ,

I won't work like this, take max of date from which you created Month_Year combo.

SUM({<dates={"<=$(=MAX(dates))"}>}PROV_AMOUNT)

Try this

Rgds,

Shubham

Re: month year

Brett_Bleess — Tue, 06 Aug 2019 15:05:05 GMT

Did Subham's post help you get things resolved? If so, please be sure to click the Accept as Solution button for them to give them credit for the assistance. If not, let us know where things stand. I also left you some links on the other post you had regarding the same issue as well.

You should keep things on a single thread by the way versus opening new threads...

Regards,
Brett