topic Re: Displaying a column with the value zero in QlikView

Displaying a column with the value zero

datanibbler — Mon, 10 Feb 2014 08:43:44 GMT

Hi,

I have a diagram for historical values.

- That chart (barchart) has only two dimension values:

- prior_month

- prior_week

=> The formulas are already written with an IF_condition querying the dimension so that the column for the prior_week is only displayed at that dimension_point and v.v.

=> Today I have noticed that last week, there seem to not have been any events to report

=> The value for cw 6 (prior_week) is 0

=> QlikView doesn't display this.

I already tried the ALT() function, but that doesn't work in this case - there is a numerical value, but it is 0...

There is the possible solution of introducing a second IF_construction to display this formula if the outcome is <>0 and display sth like >>> num(0.01, '#.##0') <<< alternatively.

<=> Is there any easier way? In this way, I have two nested IF_constructs in each of my two formulas which is not especially elegant...

Thanks a lot for any ideas!

Best regards,

DataNibbler

Re: Displaying a column with the value zero

whiteline — Mon, 10 Feb 2014 17:56:08 GMT

Hi.

Have you tried Properties->Presentation->Suppress Zero-Values ?

Reread the post carefully...

Could you upload a sample to play with ?

Re: Displaying a column with the value zero

datanibbler — Tue, 11 Feb 2014 07:55:45 GMT

Hi whiteline,

yes, I'll try to put together some sample data.

Right now, there's something more pressing to do, so I'll be a while in all probability.

Best regards,

DataNibbler

P.S.: That checkbox doesn't seem to do anything: My dimension looks like this

>>> IF(Zeitraum = 'Vormonat', 'Vormonat' & chr(10) & '(' & LEFT(Monthname(Monthstart(TODAY())-1), 3) & ')', 'Vorwoche' & chr(10) & '(' & (Week(TODAY())-1) & ')') <<<

(the data comes from an inline table named "Zeitraum" where there are these two entries.

You see, I have no real dimension at all, only these two data_points.