topic Re: show null as blank in QlikView

show null as blank

surajap123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

In the dataset(excel) you can see all products has no data for 'Third'(column in straight table) and Product-C also has no data for Second & Third. So i expect to show blanks in the straight table cells.

My basic formula is see the pecentage when i do- budget/sales.

In the straight table i want to represent expression output as below--

If no data in sales and budget--show black

If data in sales and budget--show the respective percentage.

My below exprssion is not working to handle nulls.

if(sum(Budget_First) = 0,0,

if(len(sum(Budget_First))=0,' ',

sum(Sales_First)/sum(Budget_First)*100))

Please help!

Re: show null as blank

MK_QSL — Wed, 21 Mar 2018 09:11:32 GMT

Something like this?

IF(IsNull(SUM(Sales_First)/SUM(Budget_First)),Null(),SUM(Sales_First)/SUM(Budget_First))

use Second and Third respectively.

Re: show null as blank

YoussefBelloum — Wed, 21 Mar 2018 09:16:16 GMT

Hi,

take a look at the background color of the expressions

PFA

Re: show null as blank

jyothish8807 — Wed, 21 Mar 2018 09:17:36 GMT

try this:

if(sum(Budget_Third) =0,'',

if(len(sum(Budget_Third)) =0,' ',

sum(Sales_Third)/sum(Budget_Third)*100))

br,
KC

Re: show null as blank

surajap123 — Wed, 21 Mar 2018 13:38:20 GMT

Thanks everyone