Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

laddu_927
Valued Contributor

Hide rows when the displayed expression has zeros when a conditional expressions are implemented.

am using a pivot table where a list box is present for the expressions i have to display. The expressions which are selected are displayed in the table. But now is there a way that I can hide the rows that have 0 or null in all the expressions that are being displayed.  And are showed if an expression with data for that row is selected. Hope am clear. Thank you in advance.

Tags (1)
6 Replies
vinieme12
Esteemed Contributor II

Re: Hide rows when the displayed expression has zeros when a conditional expressions are implemented.

please post a sample app with expected output.

QlikCommunity Tip: How to get answers to your post?

laddu_927
Valued Contributor

Re: Hide rows when the displayed expression has zeros when a conditional expressions are implemented.

Please check the attached application

sdmech81
Valued Contributor

Re: Hide rows when the displayed expression has zeros when a conditional expressions are implemented.

Try like:in calculated dimension..Hope this is wt u want?

If(a<>0,day)

vinieme12
Esteemed Contributor II

Re: Hide rows when  the displayed expression has zeros when a conditional expressions are implemented.

Hi, I will check and get back to you

laddu_927
Valued Contributor

Re: Hide rows when  the displayed expression has zeros when a conditional expressions are implemented.

Thank you Vineeth and Sachin, Actually its my bad, I new to qlikview and didn't get the working properly. I tested it . its working fine.

vinieme12
Esteemed Contributor II

Re: Hide rows when the displayed expression has zeros when a conditional expressions are implemented.

Great, keep learning buddy

Community Browser