Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
dennisnet
Partner
Partner

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

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

Pivot.PNG


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.

Knipsel.PNG

But I can not find this setting in Qlik Sense.

Any suggestions?

Thanks,

Dennis.

9 Replies
kaushiknsolanki

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
dennisnet
Partner
Partner
Author

Ok thanks Kaushik.

Any suggestions for the extension are welcom 🙂

vkish16161
Creator III
Creator III

‌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 '-'  

jonathandienst
Partner
Partner

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
vkish16161
Creator III
Creator III

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

dennisnet
Partner
Partner
Author

Nope , ALT() is not working.

These are missing values.

vkish16161
Creator III
Creator III

can you share the dimension and expression please?

dennisnet
Partner
Partner
Author

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.

richard
Partner
Partner

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