Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
sachinryeola
Contributor II
Contributor II

count in text box (Pareto Classes)

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))

    )

1 Reply
swuehl
MVP
MVP

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]