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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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

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)