topic Re: Set Analysis include values in QlikView

Set Analysis include values

amit_saini — Tue, 05 Dec 2017 05:39:11 GMT

Hi Folks,

Below is my scenario:

In Text box for Output '11611' I'm calling below expression:

=num(sum({$<Technology-={'No SCR inj','No Fuel BM'},LineSection={'Molder'},Shift_Name-={}>}GoodPieces)

Now what I'm looking for is that Output should remain always 11611 even if any users are selecting or filtering the data based on "Standard_Name" (Should includes all values)

I'm trying below expression , but it not working:

=num(sum({$<Standard_Name=,Technology-={'No SCR inj','No Fuel BM'},LineSection={'Molder'},Shift_Name-={}>}GoodPieces)

=num(sum({$<Standard_Name=p(Standard_Name),Technology-={'No SCR inj','No Fuel BM'},LineSection={'Molder'},Shift_Name-={}>}GoodPieces)

Please suggest what should be right logic.

Regards,

Re: Set Analysis include values

Anil_Babu_Samineni — Tue, 05 Dec 2017 05:42:26 GMT

What if we use {1} with in the identifier?

Re: Set Analysis include values

amit_saini — Tue, 05 Dec 2017 05:48:19 GMT

Anil I can do something like below:

Sum({1} [Sales]) : sum of everything (All dimensions are completely reset to All)

But my issue is selections should applicable on other fields like Technology , LineSection ...etc , but not only on Standard_Name

Regards,

Amit

Re: Set Analysis include values

Anil_Babu_Samineni — Tue, 05 Dec 2017 05:53:25 GMT

True, When we cover P() it will filter for all possible values

=num(sum({1<Standard_Name=p(Standard_Name),Technology-={'No SCR inj','No Fuel BM'},LineSection={'Molder'},Shift_Name-={}>}GoodPieces)

Re: Set Analysis include values

Anonymous — Tue, 05 Dec 2017 05:59:17 GMT

try this...

num(sum({<Standard_Name=>} aggr({<Standard_Name=>}

sum({<Technology-={'No SCR inj','No Fuel BM'},LineSection={'Molder'},Shift_Name-={}>}GoodPieces)

, Standard_Name)))

Re: Set Analysis include values

amit_saini — Tue, 05 Dec 2017 06:02:11 GMT

What shall I do if I want my set expression to be independent of any selections from "Standard_Name"???

Regards,

Re: Set Analysis include values

Anonymous — Tue, 05 Dec 2017 06:06:16 GMT

The above expression would actually actually ignores only standard_Name

Re: Set Analysis include values

amit_saini — Tue, 05 Dec 2017 06:11:11 GMT

I tried below as it's working :

(num(sum({$<Technology-={'No SCR inj','No Fuel BM'},LineSection={'Molder'},Shift_Name-={},Standard_Name=>}GoodPieces))

Regards,

Re: Set Analysis include values

Anil_Babu_Samineni — Tue, 05 Dec 2017 06:14:05 GMT

Does that mean, The sequential order working for you? Seems you just placed ignore field to the last place. Is that is the cause? I wonder

Re: Set Analysis include values

amit_saini — Tue, 05 Dec 2017 06:16:44 GMT

Yes right it was sequence issue , looks like in data set Standard_Name is lowest Hierarchy.

Regards,