topic Re: set analysis problem in QlikView

set analysis problem

adiarnon — Wed, 03 Jun 2015 07:23:30 GMT

hi,

i have this expression

(NOT working)

count({<Task_MS={'1'},Perf_CC=,Lead_CC={=GetFieldSelections(Perf_CC)}>}DISTINCT Task_ID)

how can i fix it?

adi

Re: set analysis problem

avinashelite — Wed, 03 Jun 2015 07:26:54 GMT

try like this:

count({<Task_MS={'1'},Perf_CC=,Lead_CC={"=GetFieldSelections(Perf_CC)"}>}DISTINCT Task_ID)

Re: set analysis problem

PrashantSangle — Wed, 03 Jun 2015 07:29:35 GMT

Hi,

Try this

count({<Task_MS={'1'},Perf_CC=,Lead_CC={"$(=GetFieldSelections(Perf_CC))"}>}DISTINCT Task_ID)

Regards

Re: set analysis problem

rubenmarin — Wed, 03 Jun 2015 07:35:44 GMT

Hi adi, you also can try this:

count({<Task_MS={'1'},Perf_CC=,Lead_CC={$(=Chr(39) & Concat(Distinct Perf_cc, Chr(39) & ',' & Chr(39)) & Chr(39))}>}DISTINCT Task_ID)

Re: set analysis problem

adiarnon — Wed, 03 Jun 2015 08:56:12 GMT

working!!

Re: set analysis problem

pratap6699 — Wed, 03 Jun 2015 08:58:40 GMT

count({<Task_MS={'1'},Perf_CC=,Lead_CC={"=$(=GetFieldSelections(Perf_CC))"}>}DISTINCT Task_ID)

Re: set analysis problem

adiarnon — Wed, 03 Jun 2015 13:23:14 GMT

HI,

BUT WHEN IM NOT CHOOSING "Perf_CC"

ITS SHOW ME ALWAYS 0

I WANT IT TO BE LIKE

count({<Task_MS={'1'},Perf_CC=,Lead_CC="}>}DISTINCT Task_ID)

Re: set analysis problem

PrashantSangle — Thu, 04 Jun 2015 03:59:04 GMT

Hi,

Use if condition for it

like if(getSelectedCount(Perf_CC)>0,

count({<Task_MS={'1'},Perf_CC=,Lead_CC={"$(=GetFieldSelections(Perf_CC))"}>}DISTINCT Task_ID),

count({<Task_MS={'1'},Perf_CC=,Lead_CC=>}DISTINCT Task_ID)

)

Regards

Re: set analysis problem

adiarnon — Thu, 04 Jun 2015 06:00:26 GMT

hi,

tnx!

but i have 7 fields that i nssd to do it for them,

so i need to do 7 IFS?

IS there any other option?

Re: set analysis problem

adiarnon — Thu, 04 Jun 2015 06:02:14 GMT

and....

if the user filter 2 fields Perf_CC,Perf_ML

SO in wich if it will be?