Last Seven days count not worked properly

[gopinadhpindra]

Hi Qlik Experts,

=count({<Opened_date ={">=$(date(max(Opened_date)-7))<=$(date(max(Opened_date)))"},State={'Resolved'}>}Number)

The above expression showing total Resolved count but i need to show it as last 7 days count

please post your suggestions

Thanks

Gopinadh

[dplr-rn]

try

=count({<Opened_date ={">=$(=date(max(Opened_date)-7))<=$(=date(max(Opened_date)))"},State={'Resolved'}>}Number)

[gopinadhpindra]

@Dilip Thanks for your help but its not work properly

actually the original  date was in timestamp format and after i was converted into date format date(floor(Opened),'DD/MM/YYYY') as opened_date

might be this has been the issue or not please correct me

data is like this

Number	Priority	State	Opened	Closed	Due date
INC123	4 - Low	Open	2018-10-10 10:43:29	2018-10-10 10:43:29
INC124	4 - Low	Work in Progress	2018-10-10 10:21:26	2018-10-13 10:21:26
INC125	4 - Low	Work in Progress	2018-10-10 10:18:59	2018-10-13 10:18:59
INC126	4 - Low	Work in Progress	2018-10-10 10:16:01	2018-10-13 10:16:01
INC127	4 - Low	Open	2018-10-10 10:14:56	2018-10-13 10:14:56
INC128	4 - Low	Work in Progress	2018-10-10 10:08:41	2018-10-15 10:08:41

[dplr-rn]

Timestamp can cause issues. And should be removed or moved to a separate column

[gopinadhpindra]

already converted into the date  format date(floor(Opened),'DD/MM/YYYY') as opened_date

we can't change the master  data

Any Suggestions Plz????

[gopinadhpindra]

=count({<NEWDATE={"$(=Max(NEWDATE,7))"},State={'Resolved'}>}Number)

+count({<NEWDATE={"$(=Max(NEWDATE,6))"},State={'Resolved'}>}Number)

+count({<NEWDATE={"$(=Max(NEWDATE,5))"},State={'Resolved'}>}Number)

+count({<NEWDATE={"$(=Max(NEWDATE,4))"},State={'Resolved'}>}Number)

+count({<NEWDATE={"$(=Max(NEWDATE,3))"},State={'Resolved'}>}Number)

+count({<NEWDATE={"$(=Max(NEWDATE,2))"},State={'Resolved'}>}Number)

+count({<NEWDATE={"$(=Max(NEWDATE,1))"},State={'Resolved'}>}Number)

this exp is working fine is there any other way to make it short

[MarcoWedel]

Hi,

pay attention to your field name cases and date formats:

Your expression uses a field "Opened_date" (upper case "O") while your load script generates a field "opened_date" (lower case "o").

One possible solution might be:

=Count({$<opened_date ={">$(=Date(Max(opened_date)-7,'DD/MM/YYYY'))<=$(=Date(Max(opened_date),'DD/MM/YYYY'))"},State={'Resolved'}>}Number)

hope this helps

regards

Marco

[gopinadhpindra]

Thanks for your reply marco

Still not working its showing zero

[Anil_Babu_Samineni]

Could be format Issue? Or can you show using this below in text object and Show image?

='>=' & Date(max(Opened_date-7)) & '<=' & date(max(Opened_date))

[MarcoWedel]

seems to work for me:

hope this helps

regards

Marco