topic Re: Counting expression result in QlikView

Counting expression result

hopkinsc — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i have the following expression in a table..

IF(

SUM([raw_Overall Score])/COUNT(IF([raw_Overall Score]>0,[raw_Overall Score]))>=4.5,

'Legendary',

IF(

SUM([raw_Overall Score])/COUNT(IF([raw_Overall Score]>0,[raw_Overall Score]))>=3.5,

'Stella',

IF(

SUM([raw_Overall Score])/COUNT(IF([raw_Overall Score]>0,[raw_Overall Score]))>=2.5,

'Strong',

IF(

SUM([raw_Overall Score])/COUNT(IF([raw_Overall Score]>0,[raw_Overall Score]))>=1.5,

'Steady',

IF(

SUM([raw_Overall Score])/COUNT(IF([raw_Overall Score]>0,[raw_Overall Score]))>=0.5,

'Concern'

)))))

Is there a way to count the results of this expression and create a pie chart based on that count.

i.e.

get the count of 'Legendary' ,'Stella','Strong','Steady','Concern' and use it in a pie chart.

Sample attached.

Thanks

ychaitanya — Tue, 06 Mar 2018 18:30:26 GMT

Can't we do modelling here , Suggest by placing them in the script which would be the ideal case.

else

we can add the first expression , then use the Column(1) to play on the first expression and increment the counters.

sunny_talwar — Tue, 06 Mar 2018 19:03:38 GMT

This?

hopkinsc — Wed, 07 Mar 2018 00:00:23 GMT

yet again, Thanks!!