topic Combo_chart with two expressions - write in the columns? in QlikView

Combo_chart with two expressions - write in the columns?

datanibbler — Tue, 15 Oct 2013 12:54:29 GMT

Hi,

I have a combo chart displaying a completion_status (between 0% and 100%) of two elements:

- QlikView apps

- the resp. documentations

There are two columns for every dimension_point side by side

They are all coloured acc. to the range of their value, so they may have the same colour

=> I would like to make it easier to tell which is which, either by using a second dimension (I tried that, but it didn't show?!)

or preferably by writing "App" or "documentation" inside the columns - is that possible?

Thanks a lot!

Best regards,

DataNibbler

Re: Combo_chart with two expressions - write in the columns?

datanibbler — Tue, 15 Oct 2013 13:08:39 GMT

Hi,

I have looked up the DUAL() fct. and implemented that in my script:

- There are two fields in my base file:

- Teamboard

- Status

- I would like to display the Status on the y-axis of my chart, but display the name of the Teamboard, not only as dimension, but within the column as well.

=> I have one line in my LOAD statement that reads

>>> DUAL(Status, Teamboard) as Status <<<

However, when i reload, the chart gets very big and the y-axis disappears altogether.

Can someone help me here?