Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to overlap the lines in the chart below. I am not sure how to add a dimension that basically adds a count to each different tag starting at zero. I have more tags so creating a script with these tag names will not be a solution for me.
My dataset is essentially tag: value.
Instead I am currently getting this where all the lines are starting one after the other.
Current Dimesion is the incremental cound ID for each record. The measure is the TagValue. So my table looks like:
ID, TagName, TagValue
1, tag1, 23
2, tag1, 42
3, tag4, 32
4, tag1, 50
5, tag3, 30
So I essentially need:
1, tag1, 23
2, tag1, 42
1, tag4, 32
3, tag1, 50
1, tag3, 30
P.S I am very new to qlikview so replying with a script code may also require an explanation on where to put the script.
Thanks in advance!
Liam
Could you please share the current dimension and measure in your chart and sample data set .......
I am not able to provide the dataset sample, but I hope the edit helps understand what I am working with.
have to checked the force zero option in chart properties?
The forced zero option for the expression axis is used, but I am not able to do the same with the dimension axis. It is greyed out.
Is this the right place?