topic Re: Use an expression result within another expression in QlikView

Use an expression result within another expression

Thu, 15 Nov 2012 08:57:33 GMT

Is it possible to create a new expression to calculate the amount of instances whereby a number is greater than a predefined number, and then use the results of that expression within another expression?

Re: Use an expression result within another expression

Gysbert_Wassenaar — Thu, 15 Nov 2012 09:09:47 GMT

Yes, that's possible. To make reuse easier and improve readability you can put the first expression in a variable and use the variable in the second expression.

vSumSales: sum(Sales)

Expression2: aggr($(vSumSales),Month)

Re: Use an expression result within another expression

Thu, 15 Nov 2012 09:19:30 GMT

Hi I have tried to put my first expression in a variable as you have stated but the data just disappears.

my expression reads:

vDelayMins: Sum(SCH)-Sum(CHKS)

then I was going to load DelayMins to calculate the amount of data that has a value of -15 or more

Re: Use an expression result within another expression

Gysbert_Wassenaar — Thu, 15 Nov 2012 09:29:23 GMT

See attached example. It has a variable vYearDiff that calculates the sales difference between two years. This variable is then used in the expression Diff 2008 - 2009 in the straight table: if($(vYearDiff)>0,'Up','Down'). If the result of vYearDiff > 0 then sales increased, otherwise the declined.

Re: Use an expression result within another expression

Thu, 15 Nov 2012 09:36:13 GMT

Im not able to load the file as I did not create it

Re: Use an expression result within another expression

Thu, 15 Nov 2012 10:07:29 GMT

I have taken a screen shot can you advise where I am going wrong.

Instaed of a - the two columns should be displaying the same information. once I get the first column to deiplay the correct informtion I can then start to build the if statement to calculate the number greater than -15

Re: Use an expression result within another expression

Gysbert_Wassenaar — Thu, 15 Nov 2012 10:26:23 GMT

Well, to begin with get rid of the vDelayMins: in the expression. Then it looks the same as your second expression. It will work, but that's probably not what you want. If you press CTRL+V the variables screen opens. If you click on Add you can add a variable you can name vDelayMins. Once you've added it you can click on it and give it as value Sum(SCH)-Sum(CHKS). You can then create an expression in your chart with for example as definition if($(vDelayMins)<-15,'Delayed','Not Delayed')

Re: Use an expression result within another expression

Thu, 15 Nov 2012 11:18:15 GMT

Hi firstly as I havent stated yet thank you so much for trying to help me resolve this issue with such prompt responses.

I have took two more screenshots as I had initially done as you said but the information still showed a -

Re: Use an expression result within another expression

Gysbert_Wassenaar — Thu, 15 Nov 2012 11:21:32 GMT

You didn't do the dollar expansion yet. Change the definition of the expression to $(DELAYMIN)

Re: Use an expression result within another expression

Thu, 15 Nov 2012 11:26:37 GMT

Hi that worked a treat figures populated thanks so much, my second part I had hoped would have been resolved by the if statement you created it shows all as not delayed if if the value is less than -15 ie say -3 still showing not delayed