Displaying a column with the value zero

[datanibbler]

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

[whiteline]

Hi.

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

Reread the post carefully...

Could you upload a sample to play with ?

[datanibbler]

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.