Set Analysis?

[prajapatiamar38]

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

[vardhancse]

Hi Try,

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

[amit_saini]

Hi,

Try :

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

Thanks,

AS

[#4]

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

[prajapatiamar38]

Hi

I tried it but it is not correct.

[qlikmsg4u]

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)

[prajapatiamar38]

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

Thanks

[qlikmsg4u]

tried the above expression?

[tresesco]

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

[prajapatiamar38]

HI

I Have tried but its giving an error