topic Re: Set Analysis Problem in QlikView

Set Analysis Problem

Simon_J — Thu, 21 Nov 2013 10:32:53 GMT

I have a dashboard that has revenue for different time periods, however in one of the charts the calculation must look at revenue for the current month and year and be able to filter down on selections.

sum({<Monthyear={"$(vcurrentmonthyear)"}>}Revenuesum)/1000

The problem i have is that if a user clicks a different month in the dashboard, the chart changes because of the $ expansion.

How can i force the expression to only look at the current month. If i take the $ out, the variable errors.

Many Thanks,

Simon

Re: Set Analysis Problem

davidrobles — Thu, 21 Nov 2013 10:44:09 GMT

vcurrentmonthyear

Define variable

=month(today())

Re: Set Analysis Problem

Simon_J — Thu, 21 Nov 2013 10:47:44 GMT

vcurrentmonthyear = Monthname(today());

Re: Set Analysis Problem

daveamz — Thu, 21 Nov 2013 10:49:31 GMT

Hi Simon,

Check the document attached.

Best Regards,

David

Re: Set Analysis Problem

Simon_J — Thu, 21 Nov 2013 10:54:57 GMT

Thats great, thank you very much