Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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)