topic Re: Calculate a variable's parameter as set-analysis in QlikView

Calculate a variable's parameter as set-analysis

Mon, 25 Aug 2014 08:49:29 GMT

I have a variable that I sometimes want to use set analysis on (but not always).

I want to be able to use it as it is - i.e:

=$(sum_num)

--> would calculate sum(num)

or, alternatively use a parameter to pass a set analysis expression

=$(sum_num({<country={'US'}>}))

--> would calculate sum({<country={'US'}>} num)

_______________

What I've tried so far:

sum($1 num)

gives errors when I don't pass any variable (works great for =$(sum_num({<country={'US'}>})) though)

I've also tried

sum(if(NOT isNull($1),$1) num)

and

sum(alt($1,'') num)

But neither of those are working.

Any ideas?

Thanks

Re: Pass set-analysis as a variable's parameter

CELAMBARASAN — Mon, 25 Aug 2014 08:56:54 GMT

Your variable value should be

='Sum($1 num)'

then try this in text object or chart expression

=$(sum_num({<country={'US'}>}))

Re: Pass set-analysis as a variable's parameter

jonathandienst — Mon, 25 Aug 2014 08:56:56 GMT

Try this (not tested) - Sum(If(Len('$1')=0,{$}, $1) num)

HTH

Jonathan

Re: Pass set-analysis as a variable's parameter

Mon, 25 Aug 2014 08:59:39 GMT

Thanks, but it only works for

=$(sum_num({<country={'US'}>}))

not for

=$(sum_num5)

Re: Pass set-analysis as a variable's parameter

Mon, 25 Aug 2014 09:04:05 GMT

Doesn't work unfortunately. Good idea regarding {$} though - I'll experiment a bit with that

Re: Calculate a variable's parameter as set-analysis

jonathandienst — Mon, 25 Aug 2014 12:43:38 GMT

Did you try

=$(sum_num5())

Re: Pass set-analysis as a variable's parameter

CELAMBARASAN — Mon, 25 Aug 2014 12:49:01 GMT

Hi,

to use with setanalysis

=$(sum_num({<country={'US'}>}))

without set analysis use

=$(sum_num({$}))

May this approach might helps

Re: Calculate a variable's parameter as set-analysis

Tue, 26 Aug 2014 07:00:47 GMT

I found a work around. SET SumNum = sum({<$1>} num) works with =$(SumNum(Country={'US'})). It gives a bit of an ugly result (sum({<$1>} num)) if you don't give any parameter, but it works.