Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can you advise if the below set analysis will work in Qlik Sense?
It doesn't seem to be working for me.
concat(distinct {<Name={"=count(Name)>=1")>} Name)
I have written this expression just for testing purpose only.
Thanks,
Sri
I think it should work. Can you share a sample of where it isn't working?
It works.
I had some syntax error .. Lol
concat(distinct {<Name={"=count(Name)>=1"}>} Name)
instead of
concat(distinct {<Name={"=count(Name)>=1")>} Name)
By the qlik sense syntax is hard to look at. it is so small
try wit single quotes
concat(distinct {<Name={'=count(Name)>=1'}>} Name)
Hello Sri -
If you have not seen the videos on Set Analysis - you can review them here:
What you are trying to achieve when using Set Analysis is what we call $ (dollar) expansion, which is the ability to evaluate the function and obtain the results to be used for your comparison. You can see it in action here in video #2 on YouTube on in the Qlik Community:
Set Analysis - Part 2 - Cool Stuff You can Do: Qlik Sense and QlikView - YouTube
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Regards,
Mike Tarallo
Qlik
Very Helpful for newbies.
Thanks!