Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Employee
Employee

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

HIC

sudeepkm
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)

Community Browser