topic Suppress null values in the expression in QlikView https://community.qlik.com/t5/QlikView/Suppress-null-values-in-the-expression/m-p/698533#M1073162 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I"m facing one issue, without checking the box(Suppress when value is null),can i achieve same thing in the expression.</P><P>my expression is something like this.</P><P>=IF(Index(GetSelectedField,LATEST_BOOKMARK,') &gt; 0, </P><P>if(BOOKMARK=LATEST_BOOKMARK, Hello), Hello)</P><P>after the first hello it is returning null, and if i check suppress when value is null it is hiding the entire row where the null value is present for that column(Which is impacting the other calculations as I have multiple dimension in the straight table).</P><P>Suppose i have three book mark 1,2,3 and 3rd one is the latest(getting it from the max(entrydate) column) so the moment user select the latest bookmark it should hide the others(1,2) and display the latest.</P></BODY></HTML> Fri, 01 Aug 2014 14:57:42 GMT mishraamit2485 2014-08-01T14:57:42Z Suppress null values in the expression https://community.qlik.com/t5/QlikView/Suppress-null-values-in-the-expression/m-p/698533#M1073162 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I"m facing one issue, without checking the box(Suppress when value is null),can i achieve same thing in the expression.</P><P>my expression is something like this.</P><P>=IF(Index(GetSelectedField,LATEST_BOOKMARK,') &gt; 0, </P><P>if(BOOKMARK=LATEST_BOOKMARK, Hello), Hello)</P><P>after the first hello it is returning null, and if i check suppress when value is null it is hiding the entire row where the null value is present for that column(Which is impacting the other calculations as I have multiple dimension in the straight table).</P><P>Suppose i have three book mark 1,2,3 and 3rd one is the latest(getting it from the max(entrydate) column) so the moment user select the latest bookmark it should hide the others(1,2) and display the latest.</P></BODY></HTML> Fri, 01 Aug 2014 14:57:42 GMT https://community.qlik.com/t5/QlikView/Suppress-null-values-in-the-expression/m-p/698533#M1073162 mishraamit2485 2014-08-01T14:57:42Z Re: Suppress null values in the expression https://community.qlik.com/t5/QlikView/Suppress-null-values-in-the-expression/m-p/698534#M1073163 <HTML><HEAD></HEAD><BODY><P>You can use dimension limit to handle this </P></BODY></HTML> Fri, 01 Aug 2014 15:01:36 GMT https://community.qlik.com/t5/QlikView/Suppress-null-values-in-the-expression/m-p/698534#M1073163 sujeetsingh 2014-08-01T15:01:36Z Re: Suppress null values in the expression https://community.qlik.com/t5/QlikView/Suppress-null-values-in-the-expression/m-p/698535#M1073164 <HTML><HEAD></HEAD><BODY><P>It is just showing the first record all the time, but i need something where it should show all the record but the moment i hit latest bookmark it should show only latest record.</P></BODY></HTML> Fri, 01 Aug 2014 16:54:18 GMT https://community.qlik.com/t5/QlikView/Suppress-null-values-in-the-expression/m-p/698535#M1073164 mishraamit2485 2014-08-01T16:54:18Z