Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

To display multiple selected values in dimension

Hi all,

I have a multi-box which has job-role as a field.This job role includes data like: teller, manager etc.,.

I have a pivot table with branch name,job role as dimension.

The requirement is if i select >1 value in job role box, that values have to be displayed in dimension of pivot table.

In edited dimension i used like:=if(match([Job Category],$(vRole_Selection)),[Job Category])

where (vRole_Selection)=GetFieldSelections(Job Category)

but i am not getting desired results.

4 Replies
Not applicable
Author

is there any way?

PrashantSangle

Hi,

Not clearly understood,

but i think you dont required calcualted dimension.

just add [Job Category] as dimension.

then go to chart property->General-> Calculated Condition->write below condition

if(getselectedcount([Job Category])>1,1,0)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable
Author

dreamer4

Hi,

what i mean is all the selections that  i made in drop down multi-box; they should get reflected(must come) in the chart under the corresponding branches.

say suppose; there are 2 branches "bradlee", "northsouthcarolina".

under "bradlee" branch say there are employees with "teller","teller coordinator" as  job roles/emp_roles.

and under "northsouthcarolina" branch say there are employees with only  "teller" as  job roles/emp_roles.

so if i select "teller" in multibox; under bradlee and northsouthcarolina branches it should show only "teller" under the job roles/emp_roles column which is in the chart.

if i select "teller","teller coordinator" in multibox; under bradlee it should show "teller","teller coordinator".

and under northsouthcarolina it should show only "teller".

PFA

Not applicable
Author

Hey can any one Answer this?