topic Re: Set Analysis with Variable in QlikView

Set Analysis with Variable

Anonymous — Tue, 08 Jul 2014 16:49:17 GMT

I have a variable vSales. I want to use it in a graph that shows the sales per week for the whole year. Therefore I want to ignore any time related selections.

I have used the expression:

sum({<Week=,Month=>} $(vSales))

But this doesn't work. What am I doing wrong?

Thanks

Re: Set Analysis with Variable

maxgro — Tue, 08 Jul 2014 16:54:20 GMT

how did you define vSales?

Re: Set Analysis with Variable

martynlloyd — Tue, 08 Jul 2014 16:56:57 GMT

What does vSales contain? - the value of it will directly affect the expression.

Also, don't you want to use {$<.... to base it on the current selection?

Re: Set Analysis with Variable

Tue, 08 Jul 2014 17:42:15 GMT

Hola si tu variable es vSales y esta representa un calculo con un resultado numerico debe estar en $(vSales), si vSales es un Texto que puede representar una dimension deberias ponerlo en '$(vSales)'.

Luego de que sepas que tipo de dato arroja tu vSales, podras definir el script.

Segun tu script :

suma ({} $ <Week=,Month=> (vSales))

Puede ser interpretado de la siguiente manera:

Sum({$<Week=,Month=>} $(vSales))

Sum({$<Week=,Month=>} '$(vSales)')

Re: Set Analysis with Variable

Tue, 08 Jul 2014 20:29:53 GMT

What is the definition of the vSales variable ???

is a Expression, Field, Field Condition??

DD.

Re: Set Analysis with Variable

Tue, 08 Jul 2014 21:00:45 GMT

Hi,

First, you check $(vSales) value with textbox or other tools.

When you add variable in other variable or variable in Set Analysis, you have to be sure that the variable has a correct value. I think the error is in variable's value.