Discussion Board for collaboration on QlikView Layout & Visualizations.
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?
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.
View solution in original post
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?
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!
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.