Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nvijay5757
Creator
Creator

count expression

Hi, in pivot table my data is like dimension: Program, Modes

 

in this we have to display count of KD-3(8AB,NDV,*BR)

count of nKD-2(8UNR,12AB)

count of mix like KD,nKD(10BOR)

can anyone please suggest the expression.

Labels (1)
1 Reply
eronevil
Creator
Creator

Hello,

In that table you can count those like this.

count({$ < 8UNR = {'nKD'} > }8UNR) + count({$ < 12AB= {'nKD'} > }12AB