Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using Set Analysis

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?

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

20 Replies
Josh_Good
Employee
Employee

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

MarcoWedel

Please post sample app

Not applicable
Author

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.

Not applicable
Author

James F. Walsh Jr.

MIS

ME Elecmetal

(218) 213-9571

Josh_Good
Employee
Employee

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

Anonymous
Not applicable
Author

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

Not applicable
Author

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

Anonymous
Not applicable
Author

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

or

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

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

Not applicable
Author

Error using > before the .

James F. Walsh Jr.

MIS

ME Elecmetal

(218) 213-9571