topic Re: Qlik Sense Question on Set Analysis in App Development

Qlik Sense Question on Set Analysis

Wed, 30 Mar 2016 17:41:40 GMT

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

Re: Qlik Sense Question on Set Analysis

sunny_talwar — Wed, 30 Mar 2016 17:54:55 GMT

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

Re: Qlik Sense Question on Set Analysis

Wed, 30 Mar 2016 18:04:26 GMT

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

Re: Qlik Sense Question on Set Analysis

Chanty4u — Wed, 30 Mar 2016 18:13:37 GMT

try wit single quotes

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

Re: Qlik Sense Question on Set Analysis

Michael_Tarallo — Thu, 31 Mar 2016 16:44:11 GMT

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

Re: Qlik Sense Question on Set Analysis

Dipankar_Mazumdar — Wed, 13 Jul 2016 14:55:30 GMT

Very Helpful for newbies.

Thanks!