Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Chart dimension with only labels

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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.

View solution in original post

5 Replies
Highlighted
Partner
Partner

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.

View solution in original post

Highlighted
Creator III
Creator III

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

Highlighted
Partner
Partner

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.

Highlighted
Creator III
Creator III

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

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.