QlikView App Dev

[saivina2920]

I am using  the below expression as a "dimension" for pie chart

Dimension query below.

=if(len(trim(EMPLOYEE_REASON))=0,'Others',EMPLOYEE_REASON)

Expression query below

=Count(DISTINCT EMPID_NUMBER)

In addition, i want to add more fields in the above dimension auery.

Additional fields : 

[FROM]={'*MARIAM*'},

[EMPSTATUS]={'Current'}

[TO]="$(vPlaces)"

How to add the above 3 additional condition in Dimension query for pie chart..

[MayilVahanan · Accepted solution]

HI @saivina2920 

you can apply in measure .

=Count({<[TO]={'$(vPlaces)'},[FROM]={'*MARIAM*'},[EMPSTATUS]={'Current'}>}DISTINCT EMPID_NUMBER)

[PriyankaShivhare]

May be try this:
aggr(only({<[FROM]={'*MARIAM*'},[EMPSTATUS]={'Current'}>}EMPLOYEE_REASON),EMPLOYEE_REASON)

[saivina2920]

where we can apply either dimension or expression..?

also need to add [TO]={'$(vPlaces)'}..?

[saivina2920]

Any update .

[Chanty4u · Accepted solution]

you can use in expresion only already mayil provided the expression you can use it

=Count({<[TO]={'$(vPlaces)'},[FROM]={'*MARIAM*'},[EMPSTATUS]={'Current'}>}DISTINCT EMPID_NUMBER)