count in text box (Pareto Classes)

sachinryeola — Sat, 15 Sep 2018 13:36:33 GMT

Hi,

Can anyone help me , I need to count the no of states falling under each class

I have used below expression in list box to get Pareto Class (A,B,C)

=Aggr(

If(Rangesum(Above(Sum({1} SalesNetValue)/Sum({1} total SalesNetValue),1,RowNo()))<0.8, 'A',

If(Rangesum(Above(Sum({1} SalesNetValue)/Sum({1} total SalesNetValue),1,RowNo()))<0.9, 'B',

'C')),

(StateCode,(=Sum({1} SalesNetValue),Desc))

)

Re: count in text box (Pareto Classes)

swuehl — Sat, 15 Sep 2018 18:02:07 GMT

As said in the other thread, use the aggr() function in a calculated dimension (e.g. in a straight table chart or bar chart) and use as expression

=Count(DISTINCT StateCode)

[you can also use your list box and add the Count() to the list box expressions, this would be pretty similar to the straight table version, but with the coloring of the list box dimensions]

topic count in text box (Pareto Classes) in QlikView

count in text box (Pareto Classes)

Re: count in text box (Pareto Classes)