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

[rupamjyotidas]

Taking help of sunny equation: Save the Month condition in a Variable

Let vDate= Date(MonthStart(Today(), -15);

Let vDateLabel =Date(MonthStart(Today())

In this way you can make the label change to and use the variable in other equations or field

[dandaanilreddy]

Hi Anil

I want to display last 24 weeks from current week.

Thanks

Anil

[Anil_Babu_Samineni]

This??

Sum({<Master_WeekStart = {'$(= '>=' & WeekStart(Master_WeekStart,-24) '<=' & Week(Max(Master_WeekStart)))'}>} ID)

[Anil_Babu_Samineni]

OR This

Sum({<Master_WeekStart = {'$(= '>=' & Week(WeekStart(Master_WeekStart,-25)) '<=' & Week(Max(Master_WeekStart)))'}>} ID)

[dandaanilreddy]

Thanks Got it.

Thanks

Anil

[Anil_Babu_Samineni]

If your issue got resolved then close the thread by flag of correct answer which means help full to the next customer

[hemachandran]

Hi Anil,

Try this expression,

Sum({<Master_WeekStart = {'$(= '>=' &Week(WeekStart(Master_WeekStart,-25)) '<=' & Week(Max(Master_WeekStart)))'}>} ID)

it will works..