topic Re: Previous year +1 month in QlikView

Previous year +1 month

dandaanilreddy — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Previous year +1 month

sunny_talwar — Tue, 11 Oct 2016 22:57:47 GMT

May be this:

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

Re: Previous year +1 month

sunny_talwar — Tue, 11 Oct 2016 22:59:05 GMT

If you need previous year, you can try this:

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

Re: Previous year +1 month

dandaanilreddy — Tue, 11 Oct 2016 23:14:29 GMT

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

Re: Previous year +1 month

sunny_talwar — Tue, 11 Oct 2016 23:23:25 GMT

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

Re: Previous year +1 month

dandaanilreddy — Tue, 11 Oct 2016 23:24:46 GMT

yes.

Re: Previous year +1 month

sunny_talwar — Tue, 11 Oct 2016 23:25:42 GMT

May be this:

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

Re: Previous year +1 month

dandaanilreddy — Tue, 11 Oct 2016 23:29:34 GMT

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

Thanks

Anil

Re: Previous year +1 month

dandaanilreddy — Wed, 12 Oct 2016 00:13:37 GMT

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

Re: Previous year +1 month

Anil_Babu_Samineni — Wed, 12 Oct 2016 05:11:06 GMT

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

Re: Previous year +1 month

rupamjyotidas — Wed, 12 Oct 2016 15:11:39 GMT

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

Re: Previous year +1 month

dandaanilreddy — Wed, 12 Oct 2016 16:40:51 GMT

Hi Anil

I want to display last 24 weeks from current week.

Thanks

Anil

Re: Previous year +1 month

Anil_Babu_Samineni — Wed, 12 Oct 2016 16:46:26 GMT

This??

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

Re: Previous year +1 month

Anil_Babu_Samineni — Wed, 12 Oct 2016 16:48:27 GMT

OR This

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

Re: Previous year +1 month

dandaanilreddy — Wed, 12 Oct 2016 16:58:38 GMT

Thanks Got it.

Thanks

Anil

Re: Previous year +1 month

Anil_Babu_Samineni — Thu, 13 Oct 2016 01:35:52 GMT

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

Re: Previous year +1 month

hemachandran — Thu, 13 Oct 2016 05:22:20 GMT

Hi Anil,

Try this expression,

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

it will works..