Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

microwin88x
Contributor

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

Re: Select ALL in Set Analysis with *

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)

6 Replies

Re: Select ALL in Set Analysis with *

Try to put that within Double Quotes

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

roharoha
Valued Contributor III

Re: Select ALL in Set Analysis with *

or perhaps

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

Re: Select ALL in Set Analysis with *

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
Contributor

Re: Select ALL in Set Analysis with *

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) ),'*')

Re: Select ALL in Set Analysis with *

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
Contributor

Re: Select ALL in Set Analysis with *

Thanks Sunny

Community Browser