Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Selections in formula versus list box: Selection still possible

Dear All,

I could not find a solution for this problem. I hope somebody can help me.

I have a formula in a table:

sum({<UnderwritingYear={'2005','2006','2007','2008'}>}[Premium])

If I now select in the table dimension only 2006, the table does not change.

How can I exclude/include in a formula values, but still be able to select/unselect values by clicking on a dimension or make a selection on a list box?

Many thanks.

Jan

Labels (2)
2 Solutions

Accepted Solutions
Highlighted
Specialist III
Specialist III

Hi,

Should works with

sum({<UnderwritingYear={'2005','2006','2007','2008'}> *$}[Premium])

View solution in original post

Highlighted

* is intersection operator

You could also use

 

sum({<UnderwritingYear *= {'2005','2006','2007','2008'}>} Premium)

 

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

4 Replies
Highlighted
Specialist III
Specialist III

Hi,

Should works with

sum({<UnderwritingYear={'2005','2006','2007','2008'}> *$}[Premium])

View solution in original post

Highlighted
Creator II
Creator II

Hi this is working well! Can you explain how it works? Thanks!

Highlighted

* is intersection operator

You could also use

 

sum({<UnderwritingYear *= {'2005','2006','2007','2008'}>} Premium)

 

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

Highlighted
Creator II
Creator II

Thanks for the explanation!