Total Number of rows in straight table Qlik Sense

[UserID2626]

Hi,

I need show the row count in my straight table.

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

Date	product_name	product_id	product_desc	A	B	C
01-01-2021	ABC	abc_01	*	0	0	0
01-01-2021	XYZ	xyz_01	*	0	0	0
01-01-2021	DFG	dfg_09	*]	18	0	2
01-01-2021	LMK	lmk_09	*	12	1	0
01-01-2021	HGT	hgt_05	*	0	3	4

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

[GaryGiles]

Try this:

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