topic how to use count function with if condition in QlikView

how to use count function with if condition

Tue, 08 Mar 2011 06:46:23 GMT

I want to count year, if the distinct year = 1 , then shws the list of month , otherwise list of year.

how to make if condition,

I am using this

if( count(distinct YEAR)=1 ,MONTH,YEAR)

, but it is not getting sufficient output.

Tue, 08 Mar 2011 06:53:53 GMT

Hi,

You can try this one

count(distinct if(YEAR=1,MONTH,YEAR))

Thanks & Regards

Tue, 08 Mar 2011 07:00:45 GMT

Its not working

pover — Tue, 08 Mar 2011 07:07:35 GMT

If you make a drilldown dimension group that includes year and month you will get the behavior you want and not have to use an expression.

Regards.

maneshkhottcpl — Tue, 08 Mar 2011 07:16:30 GMT

Hi,

Uneed to use the aggr function while using the nested aggrigate functions.

U can use the count(if(aggr(count(distinct YEAR),YEAR)=1,MONTH,YEAR))

Or Send me sample application

Regards

MAnesh

Tue, 08 Mar 2011 08:07:32 GMT

you can try this

Create one variable eg vCountYear and assign this

Count(DISTINCT Year) formula to it

After that in list box Expression use this

if(vcountYear=1, Month,Year)