Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
arsenal1983
Creator
Creator

Using variables in set analysis

Hi,

I would like to count all documents that have one parameter >=  defined in variable


I did this:

=count({$<PARAMETER = {$(#vPARAMETER)}>} DISTINCT DOC_NO)

it works if I would like to count DOC_NO where PARAMETER = vPARAMETER, but I would like to count DOC_NO where PARAMETER >= vPARAMETER.

regards,

L

Labels (1)
14 Replies
Anonymous
Not applicable

Correct alk‌.

But instead it could be:

count({$<PARAMETER = {">=$(=vPARAMETER+vPARAMETER3)"}>} DISTINCT DOC_NO)

arsenal1983
Creator
Creator
Author

OMG you're right!!

It's just math! You're opening my eyes.

arsenal1983
Creator
Creator
Author

One more case, I have problem with:

count({$<PARAMETER = {">=$(=vPARAMETER+PARAMETER_2)"}>} DISTINCT DOC_NO)


it always shows zero, could You help with this?

arsenal1983
Creator
Creator
Author

forget about this - i have bug in other part of the script

Not applicable

try this one ..=count({$<PARAMETER = {">=$(vPARAMETER)"}>} DISTINCT DOC_NO)