Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
YJ_SG
Contributor III
Contributor III

Individual Chart and Group Chart

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. 

To Be.jpg

 

Individual Chart

individual view.jpg

Group Chart

Group View.jpg

   

Labels (4)
1 Solution

Accepted Solutions
MayilVahanan

Hi @YJ_SG 

PFA

Try like below

MayilVahanan_R_0-1603882059540.png

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

 

Thanks & Regards,
Mayil Vahanan R

View solution in original post

8 Replies
MayilVahanan

Hi @YJ_SG 

PFA

Try like below

MayilVahanan_R_0-1603882059540.png

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

 

Thanks & Regards,
Mayil Vahanan R
YJ_SG
Contributor III
Contributor III
Author

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

Thanks & Regards,
Mayil Vahanan R
YJ_SG
Contributor III
Contributor III
Author

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.

 

Thanks & Regards,
Mayil Vahanan R
YJ_SG
Contributor III
Contributor III
Author

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.

Thanks & Regards,
Mayil Vahanan R
YJ_SG
Contributor III
Contributor III
Author

Thank you