Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
upaliwije
Contributor II

month year

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 

1 Reply
Shubham_Deshmukh
Valued Contributor

Re: month year

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