Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Please post sample app
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.
James F. Walsh Jr.
MIS
ME Elecmetal
(218) 213-9571
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
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
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
Sum ({<HotQty > {0}>}QtyToPour)
or
Sum ({$<HotQty > {0}>}QtyToPour)
qlikview assumes $ by default if no identifier is specified in set analysis
Error using > before the .
James F. Walsh Jr.
MIS
ME Elecmetal
(218) 213-9571