https://community.qlik.com/t5/QlikView/filter-for-a-null-value-and-fields-disappear-in-pivot-table/m-p/1830493#M1214483 <P>Are you saying, if you filter by a non-null value you want your object to filter to just those value(s).&nbsp; But if you filter to null value, you do not want it to filter that dimension at all?</P> Mon, 23 Aug 2021 11:05:29 GMT stevejoyce 2021-08-23T11:05:29Z https://community.qlik.com/t5/QlikView/filter-for-a-null-value-and-fields-disappear-in-pivot-table/m-p/1830454#M1214479 <P>Good Morning,<BR />I have a question about qlikview, I am starting.<BR />I have a chart of a pivot table.<BR />it has many dimensions and three expressions that are very simple (sums).<BR />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.<BR />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.<BR />can you help me? It's urgent.<BR />Thanks!</P><P>example:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lucassmitt_0-1629711902493.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60569i71CFB8DFB27D36C3/image-size/medium?v=v2&amp;px=400" role="button" title="lucassmitt_0-1629711902493.png" alt="lucassmitt_0-1629711902493.png" /></span></P><P>filter for a null value (marked in red):</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lucassmitt_2-1629712196687.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60571i74387CAB93A2BF2C/image-size/medium?v=v2&amp;px=400" role="button" title="lucassmitt_2-1629712196687.png" alt="lucassmitt_2-1629712196687.png" /></span></P><P>and the result is:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lucassmitt_1-1629712128973.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60570iB4EDBB8CF5D3FE23/image-size/medium?v=v2&amp;px=400" role="button" title="lucassmitt_1-1629712128973.png" alt="lucassmitt_1-1629712128973.png" /></span></P><P>what I want is that when filtering by a null value (marked in red) it remains as the first image. (showing all the information).</P><P>pivot table</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lucassmitt_0-1629711902493.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60569i71CFB8DFB27D36C3/image-size/medium?v=v2&amp;px=400" role="button" title="lucassmitt_0-1629711902493.png" alt="lucassmitt_0-1629711902493.png" /></span></P><P>Thanks!</P> Mon, 23 Aug 2021 09:53:02 GMT https://community.qlik.com/t5/QlikView/filter-for-a-null-value-and-fields-disappear-in-pivot-table/m-p/1830454#M1214479 lucassmitt 2021-08-23T09:53:02Z https://community.qlik.com/t5/QlikView/filter-for-a-null-value-and-fields-disappear-in-pivot-table/m-p/1830476#M1214480 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/148060">@lucassmitt</a>&nbsp;</P><P>I will move this post to the QlikView App development section.&nbsp;</P><P>I think your question can be better answered there.</P> Mon, 23 Aug 2021 10:17:36 GMT https://community.qlik.com/t5/QlikView/filter-for-a-null-value-and-fields-disappear-in-pivot-table/m-p/1830476#M1214480 Maria_Halley 2021-08-23T10:17:36Z https://community.qlik.com/t5/QlikView/filter-for-a-null-value-and-fields-disappear-in-pivot-table/m-p/1830483#M1214482 <P>Thank you very much Maria!</P> Mon, 23 Aug 2021 10:29:07 GMT https://community.qlik.com/t5/QlikView/filter-for-a-null-value-and-fields-disappear-in-pivot-table/m-p/1830483#M1214482 lucassmitt 2021-08-23T10:29:07Z https://community.qlik.com/t5/QlikView/filter-for-a-null-value-and-fields-disappear-in-pivot-table/m-p/1830493#M1214483 <P>Are you saying, if you filter by a non-null value you want your object to filter to just those value(s).&nbsp; But if you filter to null value, you do not want it to filter that dimension at all?</P> Mon, 23 Aug 2021 11:05:29 GMT https://community.qlik.com/t5/QlikView/filter-for-a-null-value-and-fields-disappear-in-pivot-table/m-p/1830493#M1214483 stevejoyce 2021-08-23T11:05:29Z https://community.qlik.com/t5/QlikView/filter-for-a-null-value-and-fields-disappear-in-pivot-table/m-p/1830504#M1214486 <P>no, what I want is that when I filter for a null value, it shows me the entire row, with all dimensions and expressions</P> Mon, 23 Aug 2021 12:34:20 GMT https://community.qlik.com/t5/QlikView/filter-for-a-null-value-and-fields-disappear-in-pivot-table/m-p/1830504#M1214486 lucassmitt 2021-08-23T12:34:20Z https://community.qlik.com/t5/QlikView/filter-for-a-null-value-and-fields-disappear-in-pivot-table/m-p/1842870#M1215351 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/148060">@lucassmitt</a>, maybe this will help, but I see that you'll looking for same behavior with a pivot table.</P> <P><A href="https://community.qlik.com/t5/New-to-Qlik-Sense/Freeze-Multiple-columns-in-straight-table-Qlik-sense/td-p/23054" target="_blank">https://community.qlik.com/t5/New-to-Qlik-Sense/Freeze-Multiple-columns-in-straight-table-Qlik-sense/td-p/23054</A></P> Wed, 06 Oct 2021 12:20:49 GMT https://community.qlik.com/t5/QlikView/filter-for-a-null-value-and-fields-disappear-in-pivot-table/m-p/1842870#M1215351 Andre_Sostizzo 2021-10-06T12:20:49Z