topic Re: IF Function in QlikView

IF Function

Thu, 19 May 2011 16:01:25 GMT

I have a problem with the if function. The calculation is bad. I define 2 variables.

v_year = 2011 and v_year_ant=2010

if((sum( {$<Year= '{$(v_year)}', Indicator = {'Sales'}>}Value ))> (sum( {$<Year= '{$(v_year_ant)}', Indicator = {'Sales'}>} Value)),1,0)

I would like to make with the function that if the sum of sales of this year is higher than the previous year gave me a value of 1 and 0 if it was not.

Were is the problem of the function

Thanks in advance

Re: IF Function

rahulgupta — Fri, 20 May 2011 07:22:35 GMT

Hey hi,

Firstly i am assuming that you are using this if condition in a Text Object....

Then use:

=if((sum( {$<Year= {$(v_year)}, Indicator = {'Sales'}>}Value )) > (sum( {$<Year= {$(v_year_ant)}, Indicator = {'Sales'}>} Value)),1,0)

I have just removed the Single Quotes you have put in the Year Selections...

Try using this..

Hope this works...!!

Re: IF Function

Fri, 20 May 2011 08:23:40 GMT

Try This:

=if((sum( {$<Year= {"=$(v_year)"}, Indicator = {"Sales"}>}Value )) > (sum( {$<Year= {"=$(v_year_ant)"}, Indicator = {"Sales"}>} Value)),1,0)