Individual Chart and Group Chart

[YJ_SG]

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

   

[MayilVahanan · Accepted solution]

Hi @YJ_SG 

PFA

Try like below

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

[YJ_SG]

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?

[MayilVahanan]

Hi @YJ_SG 

PFA.

Change the expression accordingly to ur requirement

[YJ_SG]

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?

[MayilVahanan]

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.

[YJ_SG]

Hi @MayilVahanan ,

Please forgive me if my question is too easy.

Where to control Dim is 1 or 2? 

[MayilVahanan]

Hi @YJ_SG 

You can control the values in Script.

[YJ_SG]

Thank you