topic Re: Count the date for 7 rolling days. in QlikView

Count the date for 7 rolling days.

iahmadmca1 — Tue, 18 Apr 2017 22:11:48 GMT

Team,

I am using the expression for count the 7 rolling days.so I request to everyone please suggest me to do the 7 rolling days.

Please find the below expression and make it 7 rolling days.based on file date.

=num(If(AMPM='AM',

Only({<AMPM = {PM}>} TOTAL<[TGB Name], f_date> Counts) /Only({<AMPM = {AM}>} TOTAL< [AMI TGB ID]> Counts)-1,

Only({<AMPM = {AM}>} TOTAL<[TGB Name],f_date> Counts)/ Only({<AMPM = {PM}>} TOTAL< [AMI TGB ID]> Counts) -1

),'#.##%')

Thanks,

Irshad Ahmad

Re: Count the date for 7 rolling days.

Anil_Babu_Samineni — Wed, 19 Apr 2017 02:31:56 GMT

You can use like below

Count({<Date={‘>=$(=Date(Max(DateField)-7))<=$(=Date(Max(DateField)))’}>} Measure)

Re: Count the date for 7 rolling days.

hariprasadqv — Wed, 19 Apr 2017 03:59:28 GMT

Try Rangesum() with above() for last 7 records. It will work.

Re: Count the date for 7 rolling days.

iahmadmca1 — Wed, 19 Apr 2017 13:11:59 GMT

Thanks Anil for the reply.

Re: Count the date for 7 rolling days.

iahmadmca1 — Wed, 19 Apr 2017 13:12:28 GMT

Thanks Hari for the reply.

Re: Count the date for 7 rolling days.

iahmadmca1 — Wed, 19 Apr 2017 17:48:31 GMT

Hi Anil,

could you please use my expression which I post and make it correct because I try to use the expression which you have sent but is showing error.please correct of my expression based 7 days rolling.

Thanks,

Irshad Ahmad

Re: Count the date for 7 rolling days.

Anil_Babu_Samineni — Thu, 20 Apr 2017 03:04:31 GMT

May be like this?

=Num(Count({<Date={‘>=$(=Date(Max(DateField)-7))<=$(=Date(Max(DateField)))’}>} If(AMPM='AM',

Only({<AMPM = {PM}>} TOTAL<[TGB Name], f_date> Counts) /Only({<AMPM = {AM}>} TOTAL< [AMI TGB ID]> Counts)-1,

Only({<AMPM = {AM}>} TOTAL<[TGB Name],f_date> Counts)/ Only({<AMPM = {PM}>} TOTAL< [AMI TGB ID]> Counts) -1

), Measure),'#.##%')

Re: Count the date for 7 rolling days.

iahmadmca1 — Thu, 20 Apr 2017 14:11:53 GMT

Thank you Anil !