Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @YJ_SG
PFA
Try like below
Exp: =Sum({<Group = p(Group), Person=>} Sales)
Hi @YJ_SG
PFA
Try like below
Exp: =Sum({<Group = p(Group), Person=>} Sales)
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?
Hi @YJ_SG
PFA.
Change the expression accordingly to ur requirement
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?
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.
Hi @YJ_SG
You can control the values in Script.
Thank you