topic Re: Set Analysis? in QlikView

Set Analysis?

prajapatiamar38 — Fri, 24 Jul 2015 04:53:48 GMT

Hi,
How can we write following expression in set analysis:

=Count(distinct if((CR1_Jobcardclosed_Date-CR1_Jobcard_Date))<=2,CR1_Total_Unscheduled_Jc))

Plz Help......

Thanks

Re: Set Analysis?

vardhancse — Fri, 24 Jul 2015 04:57:48 GMT

Hi Try,

Count({<Distinct(CR1_Jobcardclosed_Date-CR1_Jobcard_Date)={'<2'}>}CR1_Total_Unscheduled_Jc)

Re: Set Analysis?

amit_saini — Fri, 24 Jul 2015 05:02:55 GMT

Hi,

Try :

count({<CR1_Jobcardclosed_Date-CR1_Jobcard_Date<={'2'} >} distinct CR1_Total_Unscheduled_Jc)

Thanks,

Re: Set Analysis?

Fri, 24 Jul 2015 05:03:41 GMT

Hi,

Create one Field in Script === (CR1_Jobcardclosed_Date-CR1_Jobcard_Date) as Days_Interval

Count({<Days_Interval={"<2"}>} Distinct CR1_Total_Unscheduled_Jc)

Regards

Vimlesh

Re: Set Analysis?

prajapatiamar38 — Fri, 24 Jul 2015 05:05:50 GMT

I tried it but it is not correct.

Re: Set Analysis?

qlikmsg4u — Fri, 24 Jul 2015 05:08:39 GMT

as suggested by vimlesh20 it is better to create a new field

or something like this

=Count({<CR1_Jobcard_Date = {">$(=CR1_Jobcard_Date ) <=$(=CR1_Jobcard_Date +2)"}>} Distinct CR1_Total_Unscheduled_Jc)

Re: Set Analysis?

prajapatiamar38 — Fri, 24 Jul 2015 05:24:44 GMT

Any other solutions rather than creating field in script as suggested by vimlesh20.

Thanks

Re: Set Analysis?

qlikmsg4u — Fri, 24 Jul 2015 05:26:38 GMT

tried the above expression?

Re: Set Analysis?

tresB — Fri, 24 Jul 2015 05:29:00 GMT

=Count({<CR1_Jobcardclosed_Date-CR1_Jobcard_Date={'<=2'}>} distinct CR1_Total_Unscheduled_Jc)

Re: Set Analysis?

prajapatiamar38 — Fri, 24 Jul 2015 05:46:55 GMT

I Have tried but its giving an error

Re: Set Analysis?

tresB — Fri, 24 Jul 2015 05:51:53 GMT

Sorry, I did not notice carefully, there are two fields (and you are actually trying to calculated the difference). Try:

=Count({<CR1_Total_Unscheduled_Jc={"=CR1_Jobcardclosed_Date-CR1_Jobcard_Date<=2"}>} distinct CR1_Total_Unscheduled_Jc)

Re: Set Analysis?

prajapatiamar38 — Fri, 24 Jul 2015 06:06:40 GMT

This seems to be which I am looking for.

It works fine now.

Thank you for your help.