Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

igdrazil
Contributor III

Using $-Sign Expansion

Hi there,

as the tutorial tells me, i should be able to select values even when i use these field in set Analysis. My Formula looks like this:

sum({$<Name = {'RPL*'}>}x)

My graph is a linechart with Time and Name as Dimensions and this formula above as Measure

Time is standard time field

x are Numbers

Name got some Names like RPL_01, RPL_02, SCD_01, etc

So now i Select RPL_01 in my graph (via Legend of Name), because i only want to see this specific line, but when i accept the selection,

my graph does not change. The Selection is in the selectionbar at the top of the window but my graph did not change.

Am i doing something wrong or did i missunderstand anything of the tutorial?

Please help me.

Kind Regards

Chris

P.S.: PFA picture before & after selection and some testdata (these are not the original data due to data-safety) !

1 Solution

Accepted Solutions
MVP
MVP

Re: Using $-Sign Expansion

If I understand you correctly, you have this expression:

sum({$<Name = {'RPL*'}>}x)


The set expression here says: use current selections EXCEPT for Name; Use RPL* for Name.


So there is no issue and QS is behaving as designed. To use this together with selections, try:

sum({$<Name *= {'RPL*'}>}x)


This means Name will be the intersection of the selection and RPL*.


By the way, $ expansion refers to the expansion of variables, not the $ (current selection) set in set analysis.

8 Replies
brunobertels
Valued Contributor

Re: Using $-Sign Expansion

Hi Christoph

Add = sign in front of your dimension

For me it works :

hope it helps

igdrazil
Contributor III

Re: Using $-Sign Expansion

For me it's not, even with the = sign ...

Which version are you using? I'm using Qlik 2.1.1, could it be that there is a bug with this version, because i'm pretty sure this worked before update to 2.1.1

Regards

Chris

brunobertels
Valued Contributor

Re: Using $-Sign Expansion

hi

I use the same version as your's

Very strange because it was working for me

I've just reopened it and it does'nt work anymore.

may be a bug or a problem with 'RPL*' in the set analysis

i tried this in the Name dimension :

if(left(Name,3)='RPL',Name,null())

as dimension Name in the line graph

Then the same expression

Sum({$<Name = {'RPL*'}>}x)

and the behavior of the line graph looks OK if a clik on the legend of the line graph to select RPL 1 or 2 or 3.

But it does't work if a select RPL in the selection box.

igdrazil
Contributor III

Re: Using $-Sign Expansion

Can someone of the Dev's test this behaviour? mto


Regards

Chris

igdrazil
Contributor III

Re: Using $-Sign Expansion

Thank you so far for the help, i'll try to get someone of the Qlik staff

Regards

Chris

igdrazil
Contributor III

Re: Using $-Sign Expansion

So over 1 Month later i still have this problem.

I can't be the only one having this problem.

Is there someone of QLIK that can have a look into it (and read the posts ahead too)? mto

Regards

Chris

MVP
MVP

Re: Using $-Sign Expansion

If I understand you correctly, you have this expression:

sum({$<Name = {'RPL*'}>}x)


The set expression here says: use current selections EXCEPT for Name; Use RPL* for Name.


So there is no issue and QS is behaving as designed. To use this together with selections, try:

sum({$<Name *= {'RPL*'}>}x)


This means Name will be the intersection of the selection and RPL*.


By the way, $ expansion refers to the expansion of variables, not the $ (current selection) set in set analysis.

igdrazil
Contributor III

Re: Using $-Sign Expansion

Thank you for your answer!

Yes this solves the problem!

Regards

Chris