Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 

Set Analysis inside calculated Variable

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.



0 Replies