Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Qlik Sense Question on Set Analysis

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

5 Replies

Re: Qlik Sense Question on Set Analysis

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

Not applicable

Re: Qlik Sense Question on Set Analysis

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

sureshqv
Esteemed Contributor III

Re: Qlik Sense Question on Set Analysis

try wit single quotes

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

Employee
Employee

Re: Qlik Sense Question on Set Analysis

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

Regards,
Mike Tarallo
Qlik
bed
New Contributor

Re: Qlik Sense Question on Set Analysis

Very Helpful for newbies.

Thanks!

Community Browser