chart not showing data for 182 days ago and 365 days ago from current date

[deepakqlikview_123]

chart not showing data for 182 days ago and 365 days ago from current date

[MK_QSL]

DATE={"=$(=Date(date('2/12/2015')-182))"}

and

DATE={"=$(=Date(date('2/12/2015')-365))"}

Better option is

DATE = {">=$(=AddMonths(Max(Date),-6))"}

and

DATE = {">=$(=AddMonths(Max(Date),-12))"}

[giakoum]

use addmonths instead :

DATE={"=$(=AddMonths('2/12/2015',6))"}

[Anonymous]

You can also try creating a variable for the dates you calculate and use that in the set analysis.

I tried and its working

[deepakqlikview_123]

Hi All,

I have appliaed all above expressions in my attached application but still it is not working

Please suggest.

Thanks

[qlikmsg4u]

Hi Deepak,

What is your expected output? Dates seems to be working fine

[Anonymous]

Pls test this

For some reason the current is not working

I will try that and confirm

[antoniotiman · Accepted solution]

Hi Deepak,

in Your Expression You have :

,DATE={"=$(=date('2/12/2015'-365))"}>}

You remove '=' from  .....,DATE={"=$(

Regards,

Antonio

[deepakqlikview_123]

Hi,

As per requirement i need to show 1 line for date 2/12/2015 for all values.

second line for 182 days minus from date 2/12/2015

and third line for 365 days minus from date 2/12/2015 for all values mentioned in expression.

but it seems expression not working.

Thanks

[Anonymous]

If 2/12/2015 is the constant why don't you use the 2/12/2015-182 which is 8/16/2014 as a constant date in your expression like you did in current

btw,did you checked my attachment?It worked