Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Expression restriction

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?

2 Replies

Re: Expression restriction

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


Valued Contributor III

Re: Expression restriction

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)