topic Re: Missing Number formating in QlikView

Missing Number formating

agni_gold — Tue, 29 Aug 2017 11:06:56 GMT

Hi Friends,

I have one pivot table in which I have done suppress zero value, now in the place of Missing Values I have written 0.0, but when I exporting table to excel, then it's 0.0 will come in text format, and other will be in number format,

How can I get all number in number format?

Re: Missing Number formating

sunny_talwar — Tue, 29 Aug 2017 11:19:12 GMT

Missing values are unfortunately formatted as text... the alternative that we have used in the past is to use a macro to export the chart where we can fix the formatting

Re: Missing Number formating

agni_gold — Tue, 29 Aug 2017 12:53:39 GMT

Any other alternative ?

Re: Missing Number formating

sunny_talwar — Tue, 29 Aug 2017 12:56:04 GMT

Convert Missing Values into nulls or 0 in the script

Re: Missing Number formating

agni_gold — Tue, 29 Aug 2017 15:31:17 GMT

they are already 0 from the script , but when I am clicking on suppressing Zero values then they become "-"

Re: Missing Number formating

sunny_talwar — Tue, 29 Aug 2017 15:32:54 GMT

Then don't suppress zero values

Re: Missing Number formating

agni_gold — Tue, 29 Aug 2017 15:37:51 GMT

business want because a lot of dimension values are present which has 0 data, and the user doesn't want to see.

Re: Missing Number formating

sunny_talwar — Tue, 29 Aug 2017 15:40:01 GMT

I am confused, do they want to remove rows which are all 0s, but see other places? May be a sample might help to see how the setup is

Re: Missing Number formating

agni_gold — Tue, 29 Aug 2017 15:44:01 GMT

yes absolutely correct, when a full row is zero then suppress 0 should happen.

Re: Missing Number formating

sunny_talwar — Tue, 29 Aug 2017 15:46:50 GMT

okay

Re: Missing Number formating

rwunderlich — Wed, 30 Aug 2017 00:05:32 GMT

When you say "they are already 0 from the script", do you mean you have generated zero values for every possible combination in your pivot table?

-Rob