topic Re: Chancing the default value for missing data from '-' to zero in App Development

Chancing the default value for missing data from '-' to zero

Anonymous — Mon, 25 Sep 2017 11:58:15 GMT

Hi,

I am trying to chance the default value for missing data from '-' to 0

For example, in this pivot table the dimensions on the left has only data in some years.

The other years give a '-' , I want to change that to the number zero

Because the there is no data the IF (ISNULL ... or IF(LEN( .... trick is not a solution.

In Qlikview it can be done on the presentation tab.

But I can not find this setting in Qlik Sense.

Any suggestions?

Thanks,

Dennis.

Re: Chancing the default value for missing data from '-' to zero

kaushiknsolanki — Mon, 25 Sep 2017 12:17:45 GMT

Hi Dennis,

It is not possible as of now, because there is no setting available do to that.

You should look for some extensions from Branch.Qlik.com

Regards,

Kaushik Solanki

Re: Chancing the default value for missing data from '-' to zero

Anonymous — Mon, 25 Sep 2017 12:21:15 GMT

Ok thanks Kaushik.

Any suggestions for the extension are welcom 🙂

Re: Chancing the default value for missing data from '-' to zero

vkish16161 — Tue, 26 Sep 2017 03:25:33 GMT

‌You can use the Alt function in qlik. But this will work if your output is a numeric format.

For e.g.

Dimension : Year

Measure : Alt ( Sum(Sales) , 0 )

This will give zero as the output if the value is a '-'

Re: Chancing the default value for missing data from '-' to zero

jonathandienst — Tue, 26 Sep 2017 05:50:17 GMT

Alt() is good for nulls, but will not help for missing values. Missing values are never calculated.

Re: Chancing the default value for missing data from '-' to zero

vkish16161 — Tue, 26 Sep 2017 10:54:08 GMT

True.. but in this case Alt will work, I believe. Because, missing value is rendered as a null.

Re: Chancing the default value for missing data from '-' to zero

Anonymous — Tue, 26 Sep 2017 10:58:53 GMT

Nope , ALT() is not working.

These are missing values.

Re: Chancing the default value for missing data from '-' to zero

vkish16161 — Tue, 26 Sep 2017 14:42:48 GMT

can you share the dimension and expression please?

Re: Chancing the default value for missing data from '-' to zero

Anonymous — Thu, 28 Sep 2017 13:38:37 GMT

You can reproduce this situation with any 2 dimensions and any expression.

As long as there are missing values it shows a '-' in a pivot table.

I would like the default not to be '-' but 0.

Re: Chancing the default value for missing data from '-' to zero

richard — Fri, 09 Feb 2018 10:17:12 GMT

In your script; just use the map syntax:

F.e.

map <<Your field that can contain nulls>> using Nullmap

For your Nullmap you can use a inline table:

NullValue, NullPresentedWith

null(), 0