topic Retain fixed columns in a table with NULL records in QlikView https://community.qlik.com/t5/QlikView/Retain-fixed-columns-in-a-table-with-NULL-records/m-p/41564#M789139 <HTML><HEAD></HEAD><BODY><P>Using NULLASVALUE didn't seem to fix the below issue. Any suggestions, please? Attached is the sample qvw.</P><P></P><P>Current dataset:</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/193663_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>Current dataset after applying filter:</P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/193668_pastedImage_4.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>Expected dataset after applying filter (Low and High columns should retain their values)</P><P><IMG class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/193669_pastedImage_5.png" style="max-height: 900px; max-width: 1200px;" /><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="256"><TBODY><TR><TD height="20" style="border: 0.5pt solid windowtext; border-image: none;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Low</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">High</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Policy</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Amount</SPAN></TD></TR><TR><TD align="right" height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">50</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">100</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">90</SPAN></TD></TR><TR><TD align="right" height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">100</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">500</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">5</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">450</SPAN></TD></TR><TR><TD align="right" height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">500</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1000</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT newqlik2017 2020-11-25T16:16:04Z Retain fixed columns in a table with NULL records https://community.qlik.com/t5/QlikView/Retain-fixed-columns-in-a-table-with-NULL-records/m-p/41564#M789139 <HTML><HEAD></HEAD><BODY><P>Using NULLASVALUE didn't seem to fix the below issue. Any suggestions, please? Attached is the sample qvw.</P><P></P><P>Current dataset:</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/193663_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>Current dataset after applying filter:</P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/193668_pastedImage_4.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>Expected dataset after applying filter (Low and High columns should retain their values)</P><P><IMG class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/193669_pastedImage_5.png" style="max-height: 900px; max-width: 1200px;" /><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="256"><TBODY><TR><TD height="20" style="border: 0.5pt solid windowtext; border-image: none;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Low</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">High</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Policy</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Amount</SPAN></TD></TR><TR><TD align="right" height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">50</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">100</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">90</SPAN></TD></TR><TR><TD align="right" height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">100</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">500</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">5</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">450</SPAN></TD></TR><TR><TD align="right" height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">500</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1000</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Retain-fixed-columns-in-a-table-with-NULL-records/m-p/41564#M789139 newqlik2017 2020-11-25T16:16:04Z Re: Retain fixed columns in a table with NULL records https://community.qlik.com/t5/QlikView/Retain-fixed-columns-in-a-table-with-NULL-records/m-p/41565#M789140 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>=count(Policy) + Sum({1} 0)</STRONG></P><P><STRONG>= sum(Amount) + Sum({1} 0)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/193671_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Fri, 16 Feb 2018 19:54:41 GMT https://community.qlik.com/t5/QlikView/Retain-fixed-columns-in-a-table-with-NULL-records/m-p/41565#M789140 sunny_talwar 2018-02-16T19:54:41Z Re: Retain fixed columns in a table with NULL records https://community.qlik.com/t5/QlikView/Retain-fixed-columns-in-a-table-with-NULL-records/m-p/41566#M789141 <HTML><HEAD></HEAD><BODY><P>Nice, thank you.</P></BODY></HTML> Fri, 16 Feb 2018 20:08:55 GMT https://community.qlik.com/t5/QlikView/Retain-fixed-columns-in-a-table-with-NULL-records/m-p/41566#M789141 newqlik2017 2018-02-16T20:08:55Z