topic Re: IF in UI Level in QlikView

IF in UI Level

Wed, 19 Mar 2014 00:23:24 GMT

Hi All,

I need a small clarification on IF statement...

If we want to retrieve the value from matching fields suppose,

IF(AGE_GRP = AGE_18GROUP, POPULATION) -- won't work

POPULATION have only one value for one age group....

but if i write

sum(IF(AGE_GRP = AGE_18GROUP, POPULATION)) -- will work...

Why it need an aggregation?

Re: IF in UI Level

chiru_thota — Wed, 19 Mar 2014 02:10:49 GMT

Which object you are trying this expression actually?

Because I tried in text object & Chart.It is working fine with out Sum

Re: IF in UI Level

Wed, 19 Mar 2014 02:48:17 GMT

Just unselect the 'America' and show the result... It is not working..

Re: IF in UI Level

sundarakumar — Wed, 19 Mar 2014 03:19:39 GMT

Hi Jansi,

U require an aggregation there since the field values AGE_GRP and AGE_18Group returns more than one value when nothing is selected. It is working good in what Chirannjeevi has posted since he has selected only one value.

if AGE_GRP and AGE_18Group are relate one to one then u can use

IF(getfieldselections(AGE_GRP )= getfieldselections(AGE_18GROUP), POPULATION)

This will work if u select one entry.

Pls post sample data and specify the req so that we can help u on it.

-sundar