topic Re: How to add more condition in Dimesnion expression for Pie Chart in QlikView

How to add more condition in Dimesnion expression for Pie Chart

saivina2920 — Fri, 15 Nov 2024 23:28:40 GMT

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 — Thu, 10 Dec 2020 06:44:13 GMT

you can apply in measure .

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

PriyankaShivhare — Thu, 10 Dec 2020 06:50:49 GMT

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

saivina2920 — Thu, 10 Dec 2020 07:40:48 GMT

where we can apply either dimension or expression..?

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

saivina2920 — Thu, 10 Dec 2020 12:40:34 GMT

Any update .

Chanty4u — Fri, 11 Dec 2020 07:02:54 GMT

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)