topic Re: Calculation condition based on a variable in QlikView

Calculation condition based on a variable

Sun, 31 Mar 2013 10:46:36 GMT

Hi, I need to have a calculation condition based on a variable on a chart.

e.g. Value < $(vLimit)

vLimit is a variable that has a value. But the chart doesn't seem to take care of this condition. Can you please help?

Thanks,

Ram

Re: Calculation condition based on a variable

Jason_Michaelides — Sun, 31 Mar 2013 11:17:00 GMT

Do you mean you don't want the chart to calculate at all or do you mean an individual expression?

Re: Calculation condition based on a variable

Sun, 31 Mar 2013 11:30:22 GMT

Hi Jason,

I have a simple bar chat with 1 dimension and 1 fact(expression).The expression is sum(Value).

But I want the chart to take into consideration only those records that satisfy this condition

value < $(vLimit)

vLimit is a variable associated with an input box.

if i have rows like

dim1 Value

CON 1000

FX 2000

GA 2500

if vLimit is 1500, I want to show only CON in the chart.

Thanks

Ram

Re: Calculation condition based on a variable

Jason_Michaelides — Sun, 31 Mar 2013 16:25:20 GMT

Try setting this as your expression:

Sum({<Value={"<$(vLimit)"}>} Value)

This should sum together all rows where Value < vLimit. The total may of course be greater than vLimit as the comparison is done on a row level. Is this what you wanted?

Hope this helps,

Jason

Re: Calculation condition based on a variable

Mon, 01 Apr 2013 03:26:18 GMT

Thanks Jason. That answers my question and it is working fine.

Just want to make sure what is the utility of this Calculation condition then?

Re: Calculation condition based on a variable

Jason_Michaelides — Mon, 01 Apr 2013 09:19:14 GMT

There may be circumstances where you do not want a chart to calculate at all. for example, it might be possible to return millions and millions of rows which may endanger your production servers at affect all users. You may want to tell the chart to only calculate if it is going to return a safe number of rows or perform the calculations over a safe size dataset.