Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
NewGuyOnTheBlock
Contributor II
Contributor II

Starting each line in my chart from zero

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. 

 

How.PNG

 

Thanks in advance!

Liam

4 Replies
avinashelite

Could you please share the current dimension and measure in your chart and sample data set .......

NewGuyOnTheBlock
Contributor II
Contributor II
Author

I am not able to provide the dataset sample, but I hope the edit helps understand what I am working with. 

avinashelite

have to checked the force zero option in chart properties?

NewGuyOnTheBlock
Contributor II
Contributor II
Author

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?

 

NewGuyOnTheBlock_0-1625571906544.png