Qlik Sense Question on Set Analysis

[#1]

mto

rwunderlich

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

[sunny_talwar]

I think it should work. Can you share a sample of where it isn't working?

[#3]

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

[Chanty4u]

try wit single quotes

concat(distinct {<Name={'=count(Name)>=1'}>} Name)

[Michael_Tarallo]

Hello Sri -

If you have not seen the videos on Set Analysis - you can review them here:

• A Beginners' Introduction to Set Analysis (video)
• Set Analysis - Part 2 - Cool Stuff You Can Do (video)

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

[Dipankar_Mazumdar]

Very Helpful for newbies.

Thanks!