Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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) !
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.
Hi Christoph
Add = sign in front of your dimension
For me it works :
hope it helps
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
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.
Thank you so far for the help, i'll try to get someone of the Qlik staff
Regards
Chris
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
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.
Thank you for your answer!
Yes this solves the problem!
Regards
Chris