Select ALL in Set Analysis with *

[microwin88x]

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!!!

[sunny_talwar]

Try to put that within Double Quotes

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

[Anonymous]

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]

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 · Accepted solution]

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]

Thanks Sunny