Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator II
Creator II

Need to show row nos only when all the measures values are greater that 0

Hi there, 

I need to show the rows no in the measures field. So, I used this expression on the condition of measure

GetSelectedCount(_measures) > 0 

ashmitp869_0-1666322118486.png

and the defination is this : 

ashmitp869_1-1666322189936.png

 

 

But it showing me the rows no even the measures are 0 , like below -

ashmitp869_2-1666322278038.png

 

How can I only show the rows no when only having values in measures.

ashmitp869_3-1666322313259.png

 

Extra Notes :

The other measures contdition used - GetSelectedCount(_measures) > 0 AND SubStringCount('|' & Concat(_metricsNo, '|') & '|', '|100|')

Defination - if(rowno(total)<=1000,Sum([fieldname]))

Thanks

 

Labels (1)
1 Reply
vinieme12
Champion III
Champion III

rowno() is just to add sequential row numbers to the table

try as  below

=if( (measure1 + measure2 + measure3 + measure4) >0 ) , measure1)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.