Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
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!