topic Re: Individual Chart and Group Chart in QlikView

Individual Chart and Group Chart

YJ_SG — Sat, 16 Nov 2024 17:54:40 GMT

I am new to QlikView. I have 6 sales person in 2 groups. I create a trend chart and switch view between individual person and group. Is it possible when select a person, show this person trend chart and his group trend chart together.

Attached excel file is raw data. QVW file.

This is my goal.

Individual Chart

Group Chart

Re: Individual Chart and Group Chart

MayilVahanan — Wed, 28 Oct 2020 10:49:02 GMT

Hi @YJ_SG

PFA

Try like below

Exp: =Sum({<Group = p(Group), Person=>} Sales)

Re: Individual Chart and Group Chart

YJ_SG — Thu, 29 Oct 2020 01:00:58 GMT

Hi @MayilVahanan

Thank you. It works.

Another question, if selected 2 persons in same group, is it possible to show 3 lines. Each person individual trend + group trend?

Re: Individual Chart and Group Chart

MayilVahanan — Thu, 29 Oct 2020 02:57:40 GMT

Hi @YJ_SG

PFA.

Change the expression accordingly to ur requirement

Re: Individual Chart and Group Chart

YJ_SG — Fri, 30 Oct 2020 00:40:57 GMT

Hi @MayilVahanan ,

Thank you so much. It works perfect.

Can you explain more on expression =IF(Dim=1,Person,Group). How it able to show both Person and Group?

Re: Individual Chart and Group Chart

MayilVahanan — Fri, 30 Oct 2020 01:21:47 GMT

Hi @YJ_SG

Its a dummy dimension, which contains 1 & 2.
If the value is 1, we are assigning Person dimension values & if its 2, then we are assigning Group values.

Hope it clear.
Once the requirement is satisfied, please close the thread.

Re: Individual Chart and Group Chart

YJ_SG — Fri, 30 Oct 2020 01:28:39 GMT

Hi @MayilVahanan ,

Please forgive me if my question is too easy.

Where to control Dim is 1 or 2?

Re: Individual Chart and Group Chart

MayilVahanan — Fri, 30 Oct 2020 01:54:20 GMT

Hi @YJ_SG

You can control the values in Script.

Re: Individual Chart and Group Chart

YJ_SG — Fri, 30 Oct 2020 02:28:00 GMT

Thank you