Visualization with alternative texts

datanibbler — Fri, 13 Jul 2018 13:05:53 GMT

Hi,

in general, my task is to display data from two different tables in my datamodel side by side - one is planning_data and one is actual_data.

The complicating fact is that this chart has two dimensions. I can create that dimension in the planning_data, but it is of course named differently to avoid a loop-link.

=> So I had to insert an inline table with 8 values.

Now I have some code which worked in another chart - that was simpler - that goes like this:

>> If there is a value >0, then display this, else display a text << - whereby I used the DUAL() function with the nr. 1 to force the display of this text when there is no value to display (well, there is 0)

In this more complex chart, the code goes like that:

>> If the artificial_dimention = 'X', then IF there is a value, display this, else display a DUAL([text], 1), else display 0 << - so now I have two nested IFs.

That also works, kind of, only for the DUAL(), the chart now displays the nr. 1 when there is no value >0 - but it should display the text.

This worked in the other chart, so why doesn't it work in this one? How can I force QlikView to display the text_part of the DUAL()?

Can somebody give me a hint on how to achieve this?

Thanks a lot!

Best regards,

DataNibbler

P.S.: I forgot to mention, I have a barchart, only that last one where it worked was horizontal, this one is vertical.

topic Visualization with alternative texts in QlikView

Visualization with alternative texts