Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Creator II
Creator II

Total Number of rows in straight table Qlik Sense

Hi,

I need show the row count in my straight table.

I seen many forums but couldn't found exact result for my requirement.

Dateproduct_nameproduct_idproduct_descABC
01-01-2021ABCabc_01*000
01-01-2021XYZxyz_01*000
01-01-2021DFGdfg_09*]1802
01-01-2021LMKlmk_09*1210
01-01-2021HGThgt_05*034

 

if above table is my dashbaord.my result has to be 3

while counting rows it should not consider ABC & XYZ product because all values are zero. remaining rows has to be  considered in count because it contains atleast one KPI value>0.

Please help in getting correct result.

I tried with below conditions

Count(distinct {<A={">0"},B={">0"},C={">0"}>}product_name&product_id&product_desc)

if(A=0 and B=0 and C=0,0,Count(distinct product_name&product_id&product_desc))

Count(distinct aggr(if(A=0 and B=0 and C=0,product_name&product_id&product_desc),product_name,product_id,product_desc))

 

1 Reply
GaryGiles
Specialist
Specialist

Try this:

Count(distinct {<A-={0},B-={0},C-={0}>} product_name&product_id&product_desc)