topic Re: Custom order in line chart in QlikView

Custom order in line chart

cristianj23a — Sat, 16 Nov 2024 04:50:44 GMT

Hello, I have a line chart where I want to have the order of dates equal to my table. Example.

As we see in the image above, in the table the 29-dic is separated into two lines because they belong to two different "CAMPAÑAS". I mean that in the graph they have to appear in different lines because the objective is to separate by "CAMPAÑAS".

Try ordering but the line of the CAMP 2019 and CAMP 2017 join and should be separated.

Please help me with the topic.

I attach the Qvw.

Greetings.

Re: Custom order in line chart

bgerchikov — Fri, 04 Jan 2019 21:25:17 GMT

Hi Cristian,

the problem is your chart %s are associated with the same period, which is day-month combination. Try to add year to this combination: 29-dic-2017 and use it as a dimension.

Good luck!

Re: Custom order in line chart

jaibau1993 — Mon, 07 Jan 2019 09:54:13 GMT

Hi Cristian! I think the problem is solved if you use

=if(len(trim(PERIOD1)), Right(CAMPAÑA, 4) & '-' & PERIOD1)

as your first dimension. Please find the attached file whith my solution!

Bests,

Jaime.

Re: Custom order in line chart

cristianj23a — Mon, 07 Jan 2019 12:20:58 GMT

Hi Bgerchikov.

I understand that I have to add the Year but in this case the user does not want to add that, he wants it to remain the same but with the same when the Year is added.

Re: Custom order in line chart

cristianj23a — Mon, 07 Jan 2019 12:22:00 GMT

Hi Jaibau1993.

Is there another way where you do not have to add the CAMPAÑA?

Greetings.

Re: Custom order in line chart

jaibau1993 — Mon, 07 Jan 2019 15:14:30 GMT

Hi Cristian:

I don't think you can solve it whithout changing the dimension (as I did adding the year from CAMPAÑA). If the dimension is DAY-MONTH (as it is), then both values from 2017 and 2019 will be necessarily aligned because the tag that group both values (29-dic) is the same.

Jaime.

Re: Custom order in line chart

bgerchikov — Mon, 07 Jan 2019 17:29:29 GMT

Cristian,

In this case, I'd suggest to review this article by HIC:

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

As-of-Table may resolve your problem.