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: 
igdrazil
Creator III
Creator 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
jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

8 Replies
brunobertels
Master
Master

Hi Christoph

Add = sign in front of your dimension

For me it works :

hope it helps

igdrazil
Creator III
Creator III
Author

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

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
Creator III
Creator III
Author

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


Regards

Chris

igdrazil
Creator III
Creator III
Author

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

Regards

Chris

igdrazil
Creator III
Creator III
Author

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

jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
igdrazil
Creator III
Creator III
Author

Thank you for your answer!

Yes this solves the problem!

Regards

Chris