topic Chart dimension with only labels in QlikView

Chart dimension with only labels

danosoft — Thu, 26 Sep 2019 10:33:04 GMT

Chart dimension with only labels

Hi i attach an image with the chart: www.danosoft.it/qlikdrivers.jpg

the problem is this, the column DRIVERS need to be my dimensions, but all those are only a "label" aren't a field.

The "Act. Vs Bdg" are expression like this:

For the dimension Volumi (MWH), for column ACT is: Sum(BUD_VOLUMI) for column BDG is:Sum (TOT_CONSUMO_PERDITE)/

For the dimension "Marginalità commerciale" for column ACT is: Sum(BUD_PREZZO) for column BDG is: Sum(COSTO_RETE_VENDITA1)

For the dimension "Marginalità comm.le unitaria" for column ACT is: Sum(marc) for column BDG is: Sum(merc)

is possible to do a thing like this?

Thanks

Re: Chart dimension with only labels

jaibau1993 — Thu, 26 Sep 2019 11:20:21 GMT

Hi!

Yes, you can achieve it. You can do it using ValueList as dimension or creating island tables with the schema that you need. Take a look to the attached file.

Regards,

Jaime.

Re: Chart dimension with only labels

danosoft — Thu, 26 Sep 2019 14:43:40 GMT

Ok thanks, it work

and if i want put another Column in the first position with this label like you see in the attachment, is possible?

http://www.danosoft.it/qlikpick.jpg

Re: Chart dimension with only labels

jaibau1993 — Fri, 27 Sep 2019 06:13:28 GMT

Yes, you can. I suggest you to create an inline and isolated table to manage that kind of things if they go complicated. See the attached example.

Take into account that if you need lots of custom labels then this kind of tables may become ineficient!

Regards,

Jaime.

Re: Chart dimension with only labels

danosoft — Fri, 27 Sep 2019 07:21:30 GMT

Thanks, but i not understand how the Dim1 show only one time, how did you do that?

Re: Chart dimension with only labels

jaibau1993 — Fri, 27 Sep 2019 07:25:58 GMT

Hi!

It is just because the chart is a pivot table and i created the Inline table in a way that all three values of Dim2 have the same value of Dim1.

Jaime.