topic Re: Question on Varience in QlikView

Question on Varience

Anonymous — Fri, 23 May 2014 06:10:19 GMT

In the list box I have years from 2000 to 2014.

If I select 2012 and 2013 the variance is showing for 2013 but it is showing 0 for 2012.

The logic I implemented is:

=if(RowNo(Total)=1,0,(count(Cloumn1)-above(count(Column1))) / above(count(Column1))

Anonymous — Fri, 23 May 2014 06:15:49 GMT

Post your sample app....

Fri, 23 May 2014 06:23:49 GMT

Your year keep as variable ( v_year )

apply calculation field as

For current year

if( your_year_field_name=v_year,value_of_field_name,0)

For Previous year

if( your_year_field_name=v_year-1,value_of_field_name,0)

Variance

if( your_year_field_name=v_year,value_of_field_name,0) - if( your_year_field_name=v_year-1,value_of_field_name,0)

Hope your this is solution.