Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
danosoft
Specialist
Specialist

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
jaibau1993
Partner - Creator III
Partner - Creator III

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
jaibau1993
Partner - Creator III
Partner - Creator III

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.

danosoft
Specialist
Specialist
Author

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

jaibau1993
Partner - Creator III
Partner - Creator III

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.

danosoft
Specialist
Specialist
Author

Thanks, but i not understand how the Dim1 show only one time, how did you do that?
jaibau1993
Partner - Creator III
Partner - Creator III

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.