Set Analysis inside calculated Variable

wcilliers — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I am using a variable to store some expressions which contains set analysis. Herewith an example:

SET vGrossSales = =Sum({<TypeParent = {'Sales'}>}Amount);

When I display this variable by using vGrossSales (with / without dollar expansion), it works fine. However, If I add Months as an example to the dimensions, it adds them together for all months selected, and doesn't display the month sales individually.

I thought that it might be to do with the fact that the variable starts with =Sum and not just Sum. But that doesn't seem to work. I have also tried LET, but to no avail.

As mentioned, it is working fine, although I just want to be able to calculated the expression 'on the fly' by different dimensions.

Hope all makes sense.

Thanks,

Wynand

topic Set Analysis inside calculated Variable in QlikView

Set Analysis inside calculated Variable