I want null data to show a value.

Paknanarn23 — Sat, 04 Nov 2023 03:36:05 GMT

This is Mode data with no date selected. But KCEPart1 and Layer are selected and all data is displayed.

But when I select date KCEPart1 and Layer the data shows Null.

What I want is when the date is selected to show the mode information of KCEPart1 and Layer of another day, but the information is still of the same Part and Layer. What should I do?

This is my Mode code. I tried it. But the data is still not displayed correctly. please help me

=if(len(trim(aggr(NODISTINCT(Mode(Minimum_line_width)),KcePart1,Layer)))= '-', aggr(DISTINCT(Mode(Minimum_line_width)),KcePart1,Layer),aggr(NODISTINCT(Mode(Minimum_line_width)),KcePart1,Layer))

thank you

Re: I want null data to show a value.

ajaykakkar93 — Sat, 04 Nov 2023 13:09:29 GMT

Hi,

Option 1: Use this
If(IsNull(Sum(Value)), 0, Sum(Value))

Option 2: Sum(Value) + 0

topic I want null data to show a value. in QlikView

I want null data to show a value.

Re: I want null data to show a value.