topic Aligning Alternate State trend lines in Line chart in QlikView

Aligning Alternate State trend lines in Line chart

ngulliver — Wed, 25 Nov 2020 16:16:04 GMT

I have two alternate states showing two different products.

The end user wants to select a date range for product A and a date range for product B.

The date range chosen is different for each alternate state BUT the user wants it to appear running parallel with each other. So in the image below, they would like Product B to start at the same position as Product A regardless of the date chosen. (I know this obviously undermines the value of having a date dimension field).

The only way I can think of doing this is to manipulate the date dimension and create a numerical month (e.g. month1, month 2, month 3 etc) to compare the two. This would then enable the comparative trend lines to appear together. Is this possible ?

Is there a better way of doing this ?

Re: Aligning Alternate State trend lines in Line chart

ogautier62 — Thu, 07 Jun 2018 14:17:11 GMT

Hi Neil,

maybe in time dimension :

if(product = 'A',Month,Month - x)

with x=2 your curves are aligned

regards

Re: Aligning Alternate State trend lines in Line chart

sunny_talwar — Thu, 07 Jun 2018 15:28:00 GMT

I guess what dimension would you want to show? I mean will both the lines in the above screenshot show between 201610 to 201701 or 201608 to 201611? or you don't care what they show?