It's what I did on the second sheet on the attached .qvw to show the needs.
This solution works but is not acceptable because it has to be dynamic. There is lot of CAT in the system.
It seems like a bug, more than something else ... Because if I drop the expression in bar I get the lines I wanted ...
you said it looks like a bug and that's what comes to mind to many of us, but I think it is by design.
QV seems not to handle well line charts with more than one dimension, if you use more than one, you will get a line chart sampling point only at the first dimensions value on the x-axis. You might get around this if you use one dimension only, built from MONTH & CAT (maybe using an advanced aggregation to have the underlying dimensions still at hand).
With your requirements, I have (at least) one question:
You want to use two dimensions, CAT and MONTH and you want a bar for each CAT and MONTH.
This means your x-axis should span over both dimensions.
Then you want line chart, with a line per CAT. This sounds to me that here you want to use the second dim to generate a bundle of expression like output, i.e. your second dimension CAT should not be used for the x-axis, right? Not sure if I make myself clear, but for me that's kind of contradicting design requirement. So maybe you could clarify this to me.
If you have to make many expressions in a dynamic way you could use something like the macro code in one of the example Qlikview docs - 'Dynamic Chart' - here..http://community.qlik.com/qlikviews/1077
See the attached basic example that just adds 1 expression per CAT to your chart.
Looking at the the result though, it seems Stefan's suggestion to review the requirement is the best answer as it looks like 2 separate charts..which would be easier,
Hi, if i want to compare A an B, or B and C and D category, i create a listboxwhit categoryid and name :
A, A category
B, B category
C, C category
and in expresion condItion I write:
for A category : indicatorid=A
for B category : indicatorid=B
if i select one catoegory, its ok, it shows one category, but if i select 2 or more categorys its shows only volume, can you help?