Cannot subtract days from Week Start Date

[narband2778]

Hello Everyone,

I am using KPI object in Qlik Sense. [Week Start Date] field is in 'DD/MM/YYYY' format. Qlik Sense Forums‌

i am using below expression which is working fine.

=Count({$ < [Week Start Date] = {"$(=Max([Week Start Date]))"}>}Pat_ID)

but If I subtract  7 days from max week start date, it's not working

=Count({$ < [Week Start Date] = {"$(=Date(Max([Week Start Date])-7))"}>}Pat_ID)

Where am I doing wrong??

Thanks,

Naresh

[Thiago_Justen_]

Are you able to share a mock up with us?

[philip_doyne]

HI Naresh

Why note use WEEKSTART(today()) ....

Philip

[narband2778]

If I use the variable created by you in KPI object, it's returning Number Format of the date. Expression is returning '0'.

Still not good.

Thanks,

Naresh

[Thiago_Justen_]

What about this example?

[tamilarasu]

Try this,

=Count({$ < [Week Start Date] = {"$(=Date(Max([Week Start Date])-7,'DD/MM/YYYY'))"}>} Pat_ID )

[balabhaskarqlik]

May be this:

=Count({$ < [Week Start Date] = {'$(=Date(Max([Week Start Date])-7))'}>}Pat_ID)