Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Zero and missing values in pivot

Hi!

I have a table that is connected to another one.

When I create a pivot table for the first table I have something like this:

Month_DateDec----
BG_benchBench USDBudget%OveruseBench USDBudget%Overuse
BG162,01014456-329%-47554----
BG2028860%ok----
BG3028860%ok----
BG4028860%ok----
BG5028860%ok----
BG6028860%ok----
BG7028860%ok----
-----00-ok

I mean I dont need this "-" values, cause it looks kinda ugly.  I thing the reason is that my current table is connected to the other one.

I ticked "Suppress Zero values" and Suppress Missing, but it's still the same.

Any ideas why it can be like this?

3 Replies
Highlighted

Re: Zero and missing values in pivot

I assume those are not 0 but NULL.

Try to use ISNULL in your load or IF(TRIM(LEN(yourfield))="".....

Partner
Partner

Re: Zero and missing values in pivot

The quickest solution is to try this... remove the hyphen shown below under the 'Presentation' Tab.

Capture.PNG

Highlighted
buzzy996
Honored Contributor II

Re: Zero and missing values in pivot

are u applied on all ur dimensions in ur chart?,the same setting u mentioned this thread i.e "Suppress Zero values"!