Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.