topic Re: Line Chart for Multiple Categories in QlikView

Line Chart for Multiple Categories

Wed, 23 Jul 2014 13:37:08 GMT

Hello!

I have the following Simple Table:

Category	Jan	Feb	Mar	Jun	Jul	Aug	Sep	Oct	Nov	Dec
001	30	45	20	50	55	60	85	70	40	55
002	15	20	25	30	20	65	75	90	80	85
003	35	40	50	70	60	50	70	80	90	95

Where Category is a Dimension and Jan/Feb/Mar are Expressions.

What I want is to create a Line Chart where every line should be a different Category.

For example: I should have a line for Category 1 where values are 30, 45, 20.

X Axis: Categories by Month

Y Axis: Values (30, 45, 20)

Do you know how could I do this?

Thank you!

Re: Line Chart for Multiple Categories

datanibbler — Wed, 23 Jul 2014 13:50:17 GMT

Hi mart,

for that you'd have to turn it around and have the months as dimension and the categories as expressions - one line represents one expression running along a dimension, so if your months are your dimension, you can have three expressions = three lines.

HTH

Best regards,

DataNibbler

Re: Line Chart for Multiple Categories

Wed, 23 Jul 2014 13:55:24 GMT

Thanks for your answer.

But I don't know how many Categories could I have because it depends on those who are imported from a QVD and it also depends on the selected date, that's where the value vary and also the Categories shown.

Re: Line Chart for Multiple Categories

Gysbert_Wassenaar — Wed, 23 Jul 2014 13:56:07 GMT

It can't be done with the months as expressions. If you use more than one expression then each expression will get a line. What you can do if your source data is in the format you posted is use the Crosstable function to transform the data and create a Month field. See attached example.

Re: Line Chart for Multiple Categories

Wed, 23 Jul 2014 13:56:19 GMT

Can you attach a sample file for analysis, if possible?

Category	Jan	Feb	Mar	Jun	Jul	Aug	Sep	Oct	Nov	Dec
001	30	45	20	50	55	60	85	70	40	55
002	15	20	25	30	20	65	75	90	80	85
003	35	40	50	70	60	50	70	80	90	95

Category	Jan	Feb	Mar	Jun	Jul	Aug	Sep	Oct	Nov	Dec
001	30	45	20	50	55	60	85	70	40	55
002	15	20	25	30	20	65	75	90	80	85
003	35	40	50	70	60	50	70	80	90	95

Category	Jan	Feb	Mar	Jun	Jul	Aug	Sep	Oct	Nov	Dec
001	30	45	20	50	55	60	85	70	40	55
002	15	20	25	30	20	65	75	90	80	85
003	35	40	50	70	60	50	70	80	90	95