topic Re: Compare 2 selected items in one linechart in App Development

Compare 2 selected items in one linechart

Fri, 12 Feb 2016 22:18:42 GMT

Hello to all,

I'm looking for a way to display 2 lines in one linechart to show up the differences between two items e.g. 2 Groups of persons or just 2 persons.

One example:

I want to select 2 persons out of a listbox. these two Persons should be my focus for the visualizations so the linechart should show me 2 lines, where I can see the progress of the expenses over the last months for each of them. This way i can see directly the differences between these two persons. Is this possible, because, if I choose 2 persons out of a listbox, the linechart will normally present the cummulation of the values.

Thx

Re: Compare 2 selected items in one linechart

sunny_talwar — Fri, 12 Feb 2016 23:08:20 GMT

Something like this?

Re: Compare 2 selected items in one linechart

Sat, 13 Feb 2016 07:47:09 GMT

Exactly 😉

Edit:

I just realized, that you have uploaded a file. Unfortunately, if i copy it into my Qlik SenseDesktop folder I can open the app including the loading script, but there are no worksheets, where i can see formulars or such things. Could you please tell me, what you pick as dimension and what as a measure (including necessary Formulars)?!

Thanks a lot.

Michael

Re: Compare 2 selected items in one linechart

sunny_talwar — Tue, 16 Feb 2016 10:58:21 GMT

I guess the reason you were not able to open my attachment was because I did this in QlikView. I did not notice that this was Qlik Sense. But my guess is that it should work the same way in Qlik Sense. This is what I have:

Dimension: MonthYear, Person

Expression: =Sum(Expenses)

Re: Compare 2 selected items in one linechart

Wed, 17 Feb 2016 10:19:38 GMT

Oh my god...I'am so stupid 🙂

I forgot, that I can add another dimension (<person>) to the chart. Really big thanks to you. Now it works.