Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

please post a sample app with expected output.

QlikCommunity Tip: How to get answers to your post?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
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 III
Champion III

Hi, I will check and get back to you

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
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 III
Champion III

Great, keep learning buddy

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.