topic Re: Using variables in set analysis in QlikView

Using variables in set analysis

arsenal1983 — Wed, 22 Apr 2015 12:50:02 GMT

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,

Re: Using variables in set analysis

oknotsen — Wed, 22 Apr 2015 13:03:47 GMT

How about this:

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

Re: Using variables in set analysis

Agis-Kalogiannis — Wed, 22 Apr 2015 13:12:21 GMT

Try Onno's suggestion with some extra quotes...

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

Re: Using variables in set analysis

Anonymous — Wed, 22 Apr 2015 13:18:03 GMT

Try this:

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

Re: Using variables in set analysis

arsenal1983 — Wed, 22 Apr 2015 14:39:09 GMT

Thanks, it works.:)

How about if I would like to add two dimmesions or modify vPARAMETER

example PARAMETER >= vPARAMETER - 360?

Re: Using variables in set analysis

Anonymous — Wed, 22 Apr 2015 14:55:38 GMT

Probably this:

=count({$<PARAMETER = {">=$(=vPARAMETER-360)"}>} DISTINCT DOC_NO)

notice the "=" sign before vPARAMETER, it is essential here.

Re: Using variables in set analysis

arsenal1983 — Wed, 22 Apr 2015 16:07:25 GMT

Magic! and if I would like to use another varaible instead of hardcode 360?

Re: Using variables in set analysis

Anonymous — Wed, 22 Apr 2015 16:20:06 GMT

I guess, this:

=count({$<PARAMETER = {">=$(=vPARAMETER-vPARAMETER2)"}>} DISTINCT DOC_NO)

Re: Using variables in set analysis

arsenal1983 — Tue, 28 Apr 2015 14:14:44 GMT

One more qestion, is it possible to use expresion with variable in argument of set something like:

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

Re: Using variables in set analysis

Agis-Kalogiannis — Tue, 28 Apr 2015 14:19:40 GMT

The first part of the Set modifier is the field name.

I don't think you can do something like that.

Re: Using variables in set analysis

Anonymous — Tue, 28 Apr 2015 14:59:17 GMT

Correct alk‌.

But instead it could be:

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

Re: Using variables in set analysis

arsenal1983 — Tue, 28 Apr 2015 15:04:34 GMT

OMG you're right!!

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

Re: Using variables in set analysis

arsenal1983 — Fri, 08 May 2015 14:47:18 GMT

One more case, I have problem with:

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

it always shows zero, could You help with this?

Re: Using variables in set analysis

arsenal1983 — Fri, 08 May 2015 15:27:19 GMT

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

Re: Using variables in set analysis

Fri, 08 May 2015 18:20:21 GMT

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