topic Re: To display multiple selected values in dimension in QlikView

To display multiple selected values in dimension

Mon, 28 Sep 2015 04:36:11 GMT

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.

Re: To display multiple selected values in dimension

Mon, 28 Sep 2015 05:33:58 GMT

is there any way?

Re: To display multiple selected values in dimension

PrashantSangle — Mon, 28 Sep 2015 05:44:16 GMT

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

Re: To display multiple selected values in dimension

Wed, 30 Sep 2015 05:12:09 GMT

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

Re: To display multiple selected values in dimension

Wed, 30 Sep 2015 07:50:49 GMT

Hey can any one Answer this?