topic Re: Variables with Parameters in QlikView

Variables with Parameters

felcar2013 — Wed, 17 Feb 2016 13:00:57 GMT

how can i represent a variable which ignores the Dimension?

like:

vSales($1,$2)

where

vSales = sum({$<dim1={a},dim2=>} sales)

with Parameters, how is this representation?

vSales(a,?)

i tried several Options, but None of them worked, do you have an idea on this?

thanks

Re: Variables with Parameters

marcus_sommer — Wed, 17 Feb 2016 14:46:17 GMT

You could use something like this:

vSales:

sum({$1 <$2 = {$3},$4 =>} $5)

and as expression:

$(vSales(, [dim1], 'a', [dim2], [sales]))

Re: Variables with Parameters

petter — Wed, 17 Feb 2016 15:30:39 GMT

Definition of the vSales variable with parameters:

vSales = Sum( {<$<dim1=$1,dim2=$2>} Sales )

Use of the vSales with actual parameters {a} and a space:

vSales({a}, )

notice that you have to have a space after the comma in the above expression - if you don't it will leave the $2 into the resulting evaluation....

Will give you:

Sum( {<$<dim1={a},dim2=>} Sales )

Re: Variables with Parameters

swuehl — Wed, 17 Feb 2016 15:36:12 GMT

If you are talking about ignoring the dimension, are you talking about chart dimensions?

Set expression won't ignore chart dimensions, your syntax will just clear user selections in field dim2.

If you need to ignore chart dimensions, look into TOTAL qualifier, with / without additional field list

=Sum(TOTAL Sales)

=Sum(TOTAL<Dim1> Sales)

Re: Variables with Parameters

felcar2013 — Thu, 18 Feb 2016 10:08:03 GMT

thanks, did not work

Re: Variables with Parameters

felcar2013 — Thu, 18 Feb 2016 10:16:09 GMT

this does not apply in this case, unfortunately i cannot submit data, i figure out another way of doing it

Re: Variables with Parameters

felcar2013 — Thu, 18 Feb 2016 10:20:47 GMT

this worked perfectly, thanks

Re: Variables with Parameters

petter — Thu, 18 Feb 2016 10:48:32 GMT

Sorry to hear that. I specifically tested it in a QlikView application and it worked for me. I should have attached the application I guess - since there might be subtle differences in how you apply my instructions in an application that would make a difference...

But I am happy to see that you found a solution that worked for you anyway

Re: Variables with Parameters

felcar2013 — Thu, 18 Feb 2016 15:56:05 GMT

thanks Petter

the solution from Marcus worked perfectly. I tried before all solutions like yours, but with no success. I never parametrized everything in the Expression. Now i know it is possible.