Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

line chart tow dimensions and tow measures

Hi,

there is any option to show in line chart tow dimensions and tow measures?

I need to show the quantity for each year per company and the sum of all the companies per year.

in line chart i can put only one measure and in combo chart I can Use only one dimension.

chart.png

thanks!

Tags (1)
2 Replies
MVP
MVP

Re: line chart tow dimensions and tow measures

You could create a dimension in the script for your chart that shows all companies plus a TOTAL value:

LinkTable:

LOAD Company, Company as ChartDim

RESIDENT YourTable;

CONCATENATE (LinkTable)

LOAD Company, 'TOTAL' as ChartDim

RESIDENT YourTable;

Now you can use the ChartDim dimension with your Quantity expression to show all companies in combination with the TOTAL line.

Not applicable

Re: line chart tow dimensions and tow measures

Thank you so much for your answer, swuehl, it worked very well.

Community Browser