topic Re: Set Analysis in QlikView

Set Analysis

mahendragaur — Fri, 28 Apr 2017 06:42:20 GMT

Hello,

I have a list of Process and out of which I want only Process "a" & "b" data in sheet. I used Set for the same. But my requirement is

1> If user select only process "a" then it should show data for process "a"

2> If user select any process other than "a" & "b" then it should show data for "a" & "b" only.

Attached is my qvw

Re: Set Analysis

saniyask — Fri, 28 Apr 2017 06:45:08 GMT

Hi,

Can you please reload the application and then attach it or attach the data set.

Regards,

Saniya

Re: Set Analysis

tresB — Fri, 28 Apr 2017 06:49:57 GMT

Just put a '*' before '=' in your set analysis like:

Sum({$<Process*={'a','b'}>}Value)

Re: Set Analysis

Anil_Babu_Samineni — Fri, 28 Apr 2017 06:50:11 GMT

May be this?

If(GetFieldSelections(Process)='a' or GetFieldSelections(Process)='b',Sum(Value), Sum({<Process = {'a', 'b'}>}Value))

Re: Set Analysis

manideep78 — Fri, 28 Apr 2017 06:52:12 GMT

Hi,

Here is the expression,

=If(GetFieldSelections(Process)='a' or GetFieldSelections(Process)='b', sum(Value),sum({<Process={'a','b'}>}Value))

Re: Set Analysis

manideep78 — Fri, 28 Apr 2017 06:57:05 GMT

This is amazing. tresesco‌ can you please share the resources where I can learn these type of simple tricks.

Re: Set Analysis

tresB — Fri, 28 Apr 2017 07:01:39 GMT

For this one: Implicit Set Operators

Re: Set Analysis

mahendragaur — Fri, 28 Apr 2017 07:26:31 GMT

No this is not solving my purpose because if I'm selecting any process type other than a & b then it is not showing any data.

Re: Set Analysis

mahendragaur — Fri, 28 Apr 2017 07:27:06 GMT

Thanks buddy...

Re: Set Analysis

mahendragaur — Fri, 28 Apr 2017 07:34:03 GMT

What if I need a, b and c as well

Re: Set Analysis

tresB — Fri, 28 Apr 2017 07:51:32 GMT

Yes, I did not read you right.

Re: Set Analysis

mahendragaur — Tue, 09 May 2017 07:01:34 GMT

Hello Anil,

If I have 3 process a, b and c and I want to get data for 'a' & 'b' or 'b' & 'c' then what should I do?

Do I have to use all combination of these processes in "if and else" or is there any other way to do the same?

Regards,

Mahendra

Re: Set Analysis

Anil_Babu_Samineni — Tue, 09 May 2017 07:10:42 GMT

Yes, You can use accordingly. And By chance look Pick and Match Function as well. That would more performance instead of If else condition in UI. If it is script, Then it's cool

Re: Set Analysis

mahendragaur — Tue, 09 May 2017 07:52:33 GMT

By using this method it'll be bit complex because I'm not sure for the number of processes. It is more than 8 and if I'll try to make all the combinations for this 8 and then I think it won't be possible to do with the help of this method.