topic Re: Need Help in QlikView

Need Help

gireesh1216 — Wed, 25 Nov 2020 16:16:04 GMT

Hello Team,

I have a two fields. one is STATUS_DT and second one is EMPLID. Please find attached excel file.

Requirement: I have a STATUS_DT filter and selecting two different dates(7/25/2003 and 10/30/2004) like below.But i am expecting all between dates( > =7/25/20003 to < =10/30/2004) employee count.

OUTPUT: I am selecting only two dates above but expecting all between dates employee counts like below:

Thanks,

Gireesh

Re: Need Help

jonathandienst — Sat, 29 Dec 2018 08:18:30 GMT

You need a set expression along the following lines:

Count({<STATUS_DT ={">=$(=Min(STATUS_DT))<=$(=Max(STATUS_DT))"}>} EMPLID)

The exact form depends on the data type and format of the date field. One option if the above does noit work is:

Count({<STATUS_DT ={">='$(=Date(Min(STATUS_DT)))'<='$(=Date(Max(STATUS_DT)))'"}>} EMPLID)

Add a DISTINCT if necessary:

Count({<STATUS_DT ={">=$(=Min(STATUS_DT))<=$(=Max(STATUS_DT))"}>} DISTINCT EMPLID)

Re: Need Help

gireesh1216 — Sun, 30 Dec 2018 09:48:24 GMT

Thank you..