Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
please post a sample app with expected output.
QlikCommunity Tip: How to get answers to your post?
Please check the attached application
Try like:in calculated dimension..Hope this is wt u want?
If(a<>0,day)
Hi, I will check and get back to you
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.
Great, keep learning buddy