topic Re: How to convert set expression to become dynamic in QlikView

How to convert set expression to become dynamic

paulyeo11 — Sat, 20 Apr 2013 05:29:29 GMT

Hi All

Mr Kaushik Solanki help me with the below expression :-

=money(if([Exec P&L Level] = 's','',Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-12),'YY MMM'))"}, month = >}[Amount])), $(vCurrency))

My question is how to make the above expression dynamic , meaning when i select month= jan year=2013 , it will display jan 2013 Balance sheet amount. ( now it does not allow user to select month and year , it just display max month and max year ).

https://www.dropbox.com/s/foqnz3kiddk995k/QV4FS_ver304%20ver%20009.qvw

Above link is my QV doc .

Paul

Re: How to convert set expression to become dynamic

kaushiknsolanki — Sat, 20 Apr 2013 06:45:58 GMT

Hi,

Have a look at the attachment.

Regards,

Kaushik Solanki

Re: How to convert set expression to become dynamic

Sat, 20 Apr 2013 08:19:49 GMT

HI ,

I dont what was your Requirement .

try this

=money(if([Exec P&L Level] = 's','',Sum({$<YearMonth = {"<=$(=Date(addmonths(({$}[YearMonth]),-12),'YY MMM'))"}}[Amount])), $(vCurrency))

//Yusuf Ali

Re: How to convert set expression to become dynamic

paulyeo11 — Sat, 20 Apr 2013 13:57:25 GMT

Hi Kaushik

You are very good , you able to understand what i want. by adding just year in the expression it work fine.

Paul