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

[Anonymous]

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.

[vinieme12]

please post a sample app with expected output.

QlikCommunity Tip: How to get answers to your post?

[Anonymous]

Please check the attached application

[sdmech81]

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

If(a<>0,day)

[vinieme12]

Hi, I will check and get back to you

[Anonymous]

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]

Great, keep learning buddy