Qlik Community

Deployment Framework

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pranubitla
Contributor II
Contributor II

Hide null values only in a straight table

Dear Experts,

I have a question, please help.  I have 6 dimensions in the list, I would like to hide only null values, from the 6 dimensions see the below screenshot i would like to hide all rows which are null only example last 5 rows only , if  dimension  A has a null value, Dimension B with a value, that should show.  can you suggest me something

3 Replies
maxgro
MVP
MVP

PFA

1.png

pranubitla
Contributor II
Contributor II
Author

Hi Max, I would like to show in Qlikview  Strait table, as per your screenshot, my Qlikview Straight table dimensions are  F1, F2, F3, F4, F5,  and Sum(Val),  what condition would I write to hide the last row, which is F1, F2, F3, F4, F5 all nulls. please explain

pranubitla
Contributor II
Contributor II
Author

Wonderful, Thanks Max, I did not notice your av.qvw.

resolved my issue.

Happy weekend