Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

filter for a null value and fields disappear in pivot table qlikview

Good Morning,
I have a question about qlikview, I am starting.
I have a chart of a pivot table.
it has many dimensions and three expressions that are very simple (sums).
The problem is that every time I filter by a null value of a dimension, fields disappear, that is, all dimensions appear and only expressions represent me.
On the other hand, if I filter by a value that is NOT null, if I see all the information, that is, I see all the dimensions and the three expressions.
can you help me? It's urgent.
Thanks!

example:

lucassmitt_0-1629711902493.png

filter for a null value (marked in red):

lucassmitt_2-1629712196687.png

and the result is:

lucassmitt_1-1629712128973.png

what I want is that when filtering by a null value (marked in red) it remains as the first image. (showing all the information).

pivot table

lucassmitt_0-1629711902493.png

Thanks!

5 Replies
Maria_Halley
Support
Support

@lucassmitt 

I will move this post to the QlikView App development section. 

I think your question can be better answered there.

lucassmitt
Contributor
Contributor
Author

Thank you very much Maria!

stevejoyce
Specialist II
Specialist II

Are you saying, if you filter by a non-null value you want your object to filter to just those value(s).  But if you filter to null value, you do not want it to filter that dimension at all?

lucassmitt
Contributor
Contributor
Author

no, what I want is that when I filter for a null value, it shows me the entire row, with all dimensions and expressions

Andre_Sostizzo
Digital Support
Digital Support

@lucassmitt, maybe this will help, but I see that you'll looking for same behavior with a pivot table.

https://community.qlik.com/t5/New-to-Qlik-Sense/Freeze-Multiple-columns-in-straight-table-Qlik-sense...

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up! 🙂