

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!!!
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try to put that within Double Quotes
Sum({1<CATEGORY = {"*"}, FLAG_XX = {0}>} SALES)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
or perhaps
SUM( {1< CATEGORY=P({1} CATEGORY) , FLAG_XX={0} >} SALES )

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
But you already have 1 in your set analysis... why do you need this additional condition? Are you trying to exclude nulls from CATEGORY?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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) ),'*')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Sunny
