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: 
microwin88x
Creator III
Creator III

Select ALL in Set Analysis with *

Hello,

I have an app with Qlik Sense with the following expression inside a Text Object:

SUM( {1< CATEGORY={'*'}, FLAG_XX={0} >}  SALES )

The thing is that the * doesn't work for my expression, but it works in QlikView.

Is there any way I could fix that? Or is there any issue with the asterisk symbol?

I want to select ALL values from Category.

I'm using Qlik Sense April 2018.

Thank you!!!

1 Solution

Accepted Solutions
sunny_talwar

Why do you have a plus ( + ) sign in your Concat (Chr(44))... just curious....

Why can't you do this

Sum({1<CATEGORY = p(CATEGORY), FLAG_XX = {0}>} SALES)

View solution in original post

6 Replies
sunny_talwar

Try to put that within Double Quotes

Sum({1<CATEGORY = {"*"}, FLAG_XX = {0}>}  SALES)

Anonymous
Not applicable

or perhaps

SUM( {1< CATEGORY=P({1} CATEGORY) , FLAG_XX={0} >}  SALES )

sunny_talwar

But you already have 1 in your set analysis... why do you need this additional condition? Are you trying to exclude nulls from CATEGORY?

microwin88x
Creator III
Creator III
Author

It works, but the thing is I have something like this:

Sum({1<CATEGORY={'$(vI_SELEC_CATEGORY)'}, FLAG_XX = {0}>}  SALES)


vI_SELEC_CATEGORY =

= IF( GetSelectedCount(CATEGORY)>0, CONCAT( DISTINCT CATEGORY,CHR(39)&CHR(44)&CHR(39) ),'*')

sunny_talwar

Why do you have a plus ( + ) sign in your Concat (Chr(44))... just curious....

Why can't you do this

Sum({1<CATEGORY = p(CATEGORY), FLAG_XX = {0}>} SALES)

microwin88x
Creator III
Creator III
Author

Thanks Sunny