Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Partner
Partner

Hiding rows with zero on value in expression

Hi all.

I should optionally hide rows that have zero value in one expression.


Dim1Expr1Expr2
a1001000
b2002000
c3000
d4003000
e5000
f6000


By a button I wish to hide rows c,e,f, even if Expr2 has values that are not zero.

I don't want to add 'searchable' in 'presentation tab'.

Thanks!!!!

1 Solution

Accepted Solutions
Partner
Partner

Re: Hiding rows with zero on value in expression

I found the solution.

In loading I pre-calculate my results also by joining more tables.

If the result value is zero (even if other fields are not zero) I put variable 'vZeroValue'=0 otherwise is 1.

In UI I put a button Show/Hide zero value that select 0 or 1 from hidden field vZeroValue.

View solution in original post

6 Replies

Re: Hiding rows with zero on value in expression

You mean even if Exp1 (not Exp2) has value? Try using a button to set a variable 0 or 1 and use this for your 1st expression:

If(vVar = 1, Expression,

If(Expression2Label > 0, Expression))

Expression is a placeholder here and needs to be replaced by your actual expression1

MVP
MVP

Re: Hiding rows with zero on value in expression

PFA

Partner
Partner

Re: Hiding rows with zero on value in expression

Hy Sunny!

I have to put every value (I have lots of expressions, not only 2)  like (false) zero and then in my table I have to check 'SUPPRESS ZERO-VALUE'? thanks!

Re: Hiding rows with zero on value in expression

You are right. There might be another way using a calculated dimension, but will have to look at your application before I can recommend the alternative

Partner
Partner

Re: Hiding rows with zero on value in expression

Hi Sunny! I think it is not possible in  my case.... the value zero that leads hiding all the rows is calculated by other measures, then I think it is recursive. thanks!Capture.PNG

Partner
Partner

Re: Hiding rows with zero on value in expression

I found the solution.

In loading I pre-calculate my results also by joining more tables.

If the result value is zero (even if other fields are not zero) I put variable 'vZeroValue'=0 otherwise is 1.

In UI I put a button Show/Hide zero value that select 0 or 1 from hidden field vZeroValue.

View solution in original post