Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
laddu_927
Specialist
Specialist

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.

6 Replies
vinieme12
Champion II
Champion II

please post a sample app with expected output.

QlikCommunity Tip: How to get answers to your post?

laddu_927
Specialist
Specialist
Author

Please check the attached application

sdmech81
Specialist
Specialist

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

If(a<>0,day)

vinieme12
Champion II
Champion II

Hi, I will check and get back to you

laddu_927
Specialist
Specialist
Author

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
Champion II
Champion II

Great, keep learning buddy