Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
schumi1980
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
sergio0592
Specialist III
Specialist III

Hi,

Should works with

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

View solution in original post

jonathandienst
Partner - Champion III
Partner - Champion III

* 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
sergio0592
Specialist III
Specialist III

Hi,

Should works with

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

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

jonathandienst
Partner - Champion III
Partner - Champion III

* 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
alex00321
Creator II
Creator II

Thanks for the explanation!