topic Re: Using Set Analysis in QlikView

Using Set Analysis

Thu, 18 Dec 2014 19:04:56 GMT

Sum ({1-$<HotQty = {0}>}QtyToPour)

This works on the initial selection but not if the user selects something else. How do I get this to work no more what is selected?

Re: Using Set Analysis

Josh_Good — Thu, 18 Dec 2014 19:11:31 GMT

James,

Could you please post an example and a few images of what you are seeing (and what you are expecting to see). I don't see any issue with your expression so I suspect it is 'working' but it is providing unexpected or unintended results.

-Josh
Qlik

Re: Using Set Analysis

MarcoWedel — Thu, 18 Dec 2014 19:12:00 GMT

Please post sample app

Re: Using Set Analysis

Thu, 18 Dec 2014 19:12:44 GMT

What I am looking for is that when HotQty is GREATER THEN 0, I want to see all records that meet that criteria. The user can select locations, years, and/or months for viewing and this criteria needs to be true for ALL selections but also based on their selections.

Re: Using Set Analysis

Thu, 18 Dec 2014 19:21:56 GMT

James F. Walsh Jr.

MIS

ME Elecmetal

(218) 213-9571

Re: Using Set Analysis

Josh_Good — Thu, 18 Dec 2014 19:22:04 GMT

James,

I believe this expression will work for you.

Sum({$<HotQTY = {>0}>} QtyToPour)

I am using the '$' which means to respect all the other selection vs '$-1' which means the inverse of all the other selections.

Also I'm using HotQTY = {>0} to force a selection on the HotQTY field to all values greater than zero.

Users will be able to filter on any other field besides HotQTY, which is set to >0.

-Josh

Qlik

Re: Using Set Analysis

Anonymous — Thu, 18 Dec 2014 19:27:51 GMT

Hi,

in you expression:

Sum ({1-$<HotQty = {0}>}QtyToPour)

1-$ - Returns QtyToPour for everything excluded by the current selection

as per your requirement if HotQty is GREATER THEN 0 use below expression

which Returns QtyToPour for everything included by the current selection:

Sum ({<HotQty > {0}>}QtyToPour)

Regards

Neetha

Re: Using Set Analysis

Thu, 18 Dec 2014 19:29:44 GMT

Sorry to say but that did not work (error with {>0} so I removed the >).

Then this statement did not work at all. All record are shown instead of

just the ones that are greater than 0.

James F. Walsh Jr.

MIS

ME Elecmetal

(218) 213-9571

Re: Using Set Analysis

Anonymous — Thu, 18 Dec 2014 19:31:00 GMT

Sum ({<HotQty > {0}>}QtyToPour)

Sum ({$<HotQty > {0}>}QtyToPour)

qlikview assumes $ by default if no identifier is specified in set analysis

Re: Using Set Analysis

Thu, 18 Dec 2014 19:33:57 GMT

Error using > before the .

James F. Walsh Jr.

MIS

ME Elecmetal

(218) 213-9571

Re: Using Set Analysis

Josh_Good — Thu, 18 Dec 2014 19:34:56 GMT

My apologies, I forgot the double quotes. Try this:

Sum({$<HotQTY = {">0"}>} QtyToPour)

-Josh

Qlik

Re: Using Set Analysis

Thu, 18 Dec 2014 19:35:45 GMT

Because Set Analysis uses the <> symbols, I can not use those symbols

anywhere in my statement without getting an error.

James F. Walsh Jr.

MIS

ME Elecmetal

(218) 213-9571

Re: Using Set Analysis

Thu, 18 Dec 2014 19:38:45 GMT

Sorry Josh, that did not work either. I do not get an error but nothing

changes on the report.

James F. Walsh Jr.

MIS

ME Elecmetal

(218) 213-9571

Re: Using Set Analysis

Anonymous — Thu, 18 Dec 2014 19:39:10 GMT

try :

Sum ({$<HotQty => {1}>}QtyToPour)

or Josh's solution:

Sum({$<HotQTY = {">0"}>} QtyToPour)

Re: Using Set Analysis

Thu, 18 Dec 2014 19:41:09 GMT

I already did and I get the error due to using the >.

James F. Walsh Jr.

MIS

ME Elecmetal

(218) 213-9571

Re: Using Set Analysis

Thu, 18 Dec 2014 19:45:21 GMT

Sorry Josh my mistake this time. I copied and pasted and since my variable

HotQty is this and NOT HotQTY, it did not work. Now that I have fixed

this, it does seem to be doing what I was looking for.

Thank You!

James F. Walsh Jr.

MIS

ME Elecmetal

(218) 213-9571

Re: Using Set Analysis

Josh_Good — Thu, 18 Dec 2014 19:50:54 GMT

Can you please post some sample data. That will help me check my work before sending it back.

Thanks,

Josh

Re: Using Set Analysis

Thu, 18 Dec 2014 19:51:42 GMT

Thank you for your assistance. I have received the solution.

Re: Using Set Analysis

Thu, 18 Dec 2014 19:52:29 GMT

Thank you for tapping in but I have received the solution.

Re: Using Set Analysis

Anonymous — Thu, 18 Dec 2014 19:54:18 GMT

So josh's solution worked,that's good