topic Expression restriction in QlikView

Expression restriction

Tue, 04 Feb 2014 08:46:01 GMT

Hi, I have a pivot table in qlikview which contains revenue by countries for 2012 and 2013. Countries are in rows and 2012 and 2013 is columns. I have a multi box where i have some filters. If i change the filters, both my 2012 and 2013 revenue gets changed as per the selection. But i want to see the change only in 2012 and not in 2013. Is there a way to restrict the expression for the changes to reflect only for 2012?

Re: Expression restriction

hic — Tue, 04 Feb 2014 09:28:01 GMT

You can always create two expressions - one for each year - and use Set Analysis to specify such restrictions.

But it would be extremely confusing for the end user, so I cannot recommend that you do it. Read the following blog post:http://community.qlik.com/blogs/theqlikviewblog/2014/02/03/the-key-to-heaven

HIC

Re: Expression restriction

sudeepkm — Tue, 04 Feb 2014 09:32:15 GMT

Assume that you have two other fields in your filter box like Field1, Field2 and you do not want the 2013 data not to be impacted by the filter selection. You may try an expression like below.

Dimension: Country

Expression1: sum({<Year={"$(=max(Year))"}, Field1=, Field2= >}Revenue)

Expression2: sum({<Year={"$(=max(Year)-1)"}>}Revenue)