Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have created a Variable in the Variables
vCurrentSelection =SubField(GetCurrentSelections(), ':',2)
and now I am trying to use the variable in Set analysis, but it is not working
=Count({<[Session Name] = {"$(=vCurrentSelection)"}>}[Session Name])
Can someone help me with this.
thanks in advance.
Naresh
nope
May be this -
Count({<[Session Name] = {$(=$(vCurrentSelection))}>}[Session Name])
Thanks,
RT
nope.
Thanks,
naresh
Hi Chanty,
instead of using as variable Can I use Subfield function in set analysis in Qlik Sense
=Count({$<[Session Name] = {"$(=SubField(GetCurrentSelections(), ':', 2))"}>}[Session Name])
Thanks,
Naresh
Remove the '=' sign you used while declaring variable
or
May be share a sample app?
Thanks,
RT
Try this
=Count({<[Session Name] = {"$(vCurrentSelection)"}>}[Session Name])
and Remove the '=' in variable Defination.
Might helpful..
Thanks
PM
no Luck mate. Still I am getting 0.
If I may ask, what exactly are you trying to parse out from GetCurrentSelections? Which field's value are you trying to compare to Session Name?
what is result you want to see?
because the result of your variable is
value1,Value2,value3
after that if you count it will show 1 i think. ? correct me if im wrong?
Hi Sunny,
basically I got 15 fields like [Operating name], [Session Name] and so on.
I need to count how many times a selected value will appear in all those 15 Fields.
For Example, 'XYZ' is a value in [Operating Name] and this value might be available in remaining 14 other fields. So, I want to count 'XYZ' Value in all 15 fields.
I hope my requirement is explained clearly. Let me know, if this doesn't help.
thanks in advance.
Naresh