topic Re: How to write the expression in QlikView

How to write the expression

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

Hi All,

How can implement 0 to the value in expression when the value is NULL.

See the screenshot.

In the chart ,

I have three category - Forecast Invoice Order.

But when there is no value for Forecast or Order , its not refelecting in the chart.

My Requirement, I need to show the Forecast Or Order Value which are not present by 0.

Sample Model attached.

Re: How to write the expression

Peter_Cammaert — Mon, 20 Jun 2016 12:11:56 GMT

You can try with "Show all values" on Dimension Amount Type, and disabling "Suppress zero values" in Presentation.

Note that your chart may also show Null values (can be suppressed by disabling Null values in the first Dimension) and may not show values that aren't even present in your data model. Creating dummy zero records may solve that one.

Best,

Peter

Re: How to write the expression

suvechha_b — Mon, 20 Jun 2016 12:25:19 GMT

Hi Peter,

I have tried disabling "Suppress zero values" but . If the values aren't even present in your data model.

Creating dummy zero records may solve that one. - How to create dummy zero records ?

Please can you show by exapmle.

I have attached the sample model.

Thanks,

Re: How to write the expression

Mon, 20 Jun 2016 12:25:26 GMT

Try flagging the fields in the script using something like this:

if(IsNull([Field1]), [Field1] = 0, [Field1]) as [Field1]