Previous year +1 month

[dandaanilreddy]

Hello Qlik Developers

how to get previous year date Like my expression is below. I want the date should change automatic. example the date in the expression is 10/01/2015 if i come at next month the date should be 11/01/2016

expression:

=count({<Kit={">=07/01/2015"}>} ID)

label of the expression should display nov 2015

Total kits received from oct 2015

This should convert to nov 2015

Need to display 24 weeks the week should start on sunday. Below is the expression.

=if(Master_WeekStart>='04/03/16',Master_WeekStart)

Can someone help me please.

Thanks

Anil

[sunny_talwar]

May be this:

=Count({<Kit = {"$(='>=' & Date(MonthStart(Today()), 'MM/DD/YYYY'))"}>} ID)

[sunny_talwar]

If you need previous year, you can try this:

=Count({<Kit = {"$(='>=' & Date(MonthStart(Today(), -12), 'MM/DD/YYYY'))"}>} ID)

[dandaanilreddy]

Hi Sunny

Thanks for the response

i have the below expression

expression:

=count({<Kit={">=07/01/2015"}>} ID)

The expression what you provided is displaying zero. i want the date to be automated if i go to next month.

Thanks

Anil

[sunny_talwar]

what is the next month? 08/01/2015?

[dandaanilreddy]

yes.

[sunny_talwar]

May be this:

=Count({<Kit = {"$(='>=' & Date(MonthStart(Today(), -15), 'MM/DD/YYYY'))"}>} ID)

[dandaanilreddy]

I Tried your expression but i am getting zero values. If possible check ur mobile

Thanks

Anil

[dandaanilreddy]

Thanks Sunny Bro

Its working fine.

I want to display 24 weeks the week should start on sunday. Below is the expression.

=if(Master_WeekStart>='04/03/16',Master_WeekStart). Can you help me please.

Thanks

Anil

[Anil_Babu_Samineni]

24 Weeks means, You want to show starting from Year to 24 weeks / What?