Using Set Analysis

[#1]

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?

[Josh_Good]

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

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

-Josh

Qlik

[#3]

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

[#4]

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

[Anonymous]

try :

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

or Josh's solution:

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

[#6]

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

James F. Walsh Jr.

MIS

ME Elecmetal

(218) 213-9571

[#7 · Accepted solution]

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

[Josh_Good]

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

Thanks,

Josh

[#9]

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

[#10]

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

[Anonymous]

So josh's solution worked,that's good