topic Re: prior 4 & 52 week in QlikView

prior 4 & 52 week

Mon, 06 Feb 2012 10:20:06 GMT

Hi,

I want to compare the date for same day last 4 week and 52 week.

in dimension i put day(1,2,3,4....31) i can't do this

any help or idea

Many thanks

prior 4 & 52 week

jagan — Tue, 07 Feb 2012 06:02:28 GMT

Hi,

Can you attach the sample file.

Regards,

Jagan.

prior 4 & 52 week

Tue, 07 Feb 2012 09:19:24 GMT

Hi,

Here is the chart and the set analysis expression

4 prior week =count({<CreationDate={'>=$(=monthstart(date(Today()-28)))<$(=date(monthstart(Today())))'} >} amount).

52 prior week =count({<CreationDate={'>=$(=MakeDate(Year(Today())-1, num(month(today()))))<=$(=AddYears(monthend(Today()),-1))'} >} Amount)

i want compare same day and 4 week prior.

Many thanks for your help

prior 4 & 52 week

jagan — Tue, 07 Feb 2012 09:36:57 GMT

Hi,

Please check the below expressions

This will get the prior 4th week data

=count({<CreationDate={'>=$(=WeekStart(Today()-4))<$(=WeekEnd(Today(), -4))'} >} amount)

This will get the prior 52nd week data

=count({<CreationDate={'>=$(=WeekStart(Today()-52))<$(=WeekEnd(Today(), -52))'} >} amount)

Hope this helps you.

Regards,

Jagan.

prior 4 & 52 week

Tue, 07 Feb 2012 09:54:33 GMT

Hi,

Your requirement is not clear. please mention clearly and if possible attach a sample appliation

prior 4 & 52 week

Tue, 07 Feb 2012 10:00:38 GMT

Hi,

Thanks for your reply but i still have problem i want exactly reproduit this table in chart in dimension Day

for month Fevrier so on

Day	Daily	Daily -28(4 prior week)	Daily -364( 52week prior)
1	10843,81	10815,81	10791,81
2	12211,50	12183,5	12159,5
3	12339,88	12311,88	12287,88
4	11879,32	11851,32	11827,32
5	11376,02	11348,02	11324,02
6	14062,21	14034,21	14010,21
7	10738,80	10710,8	10686,8
8	12532,88	12504,88	12480,88
9	12892,14	12864,14	12840,14
10	14036,49	14008,49	13984,49
11	10029,03	10001,03	9977,03
12	12383,33	12355,33	12331,33
13	11727,15	11699,15	11675,15
14	12370,23	12342,23	12318,23
15	11620,61	11592,61	11568,61
16	11274,52	11246,52	11222,52
17	9917,24	9889,24	9865,24
18	11279,78	11251,78	11227,78
19	11142,08	11114,08	11090,08
20	12582,85	12554,85	12530,85
21	12704,41	12676,41	12652,41
22	12234,24	12206,24	12182,24
23	12188,79	12160,79	12136,79
24	10580,92	10552,92	10528,92
25	10661,29	10633,29	10609,29
26	10876,06	10848,06	10824,06
27	10467,09	10439,09	10415,09
28	11683,10	11655,1	11631,1
29	10073,75	10045,75	10021,75
30	10728,48	10700,48	10676,48
31	7466,20	7438,2	7414,2

Thanks

prior 4 & 52 week

jagan — Tue, 07 Feb 2012 10:13:21 GMT

Hi,

Can you attach the sample file with script.

Regards,

Jagan.

prior 4 & 52 week

CELAMBARASAN — Tue, 07 Feb 2012 10:33:31 GMT

Hi,

Try with this,

4 week prior

=count({<CreationDate={'$(=Date(Num(CreationDate) - 28))'} >} amount)

52 week prior

=count({<CreationDate={'$(=Date(Num(CreationDate) - 364))'} >} amount)

Hope it helps

Celambarasan

Re: prior 4 & 52 week

Tue, 07 Feb 2012 10:57:07 GMT

Hi,

Here is.

Thanks

Re: prior 4 & 52 week

jagan — Tue, 07 Feb 2012 11:30:57 GMT

Hi,

Please check the attachment for solution.

Hope this helps you.

Regards,

Jagan.

Re: prior 4 & 52 week

perumal_41 — Tue, 07 Feb 2012 11:45:03 GMT

Hi,

Please check the attachment .

Hope this helps you.

Regards,

Perumal A

Re: prior 4 & 52 week

Tue, 07 Feb 2012 12:57:18 GMT

Hi,

I will try your solution .

Many thanks

Re: prior 4 & 52 week

Tue, 07 Feb 2012 13:14:47 GMT

Hi,

there is not a way to have this type of chart

Many thanks

Re: prior 4 & 52 week

Wed, 08 Feb 2012 09:58:32 GMT

Hi jagan mohan,

Many thanks for your solution it function very well.

Best Regards,

prior 4 & 52 week

jagan — Wed, 08 Feb 2012 10:27:21 GMT

Hi,

Please mark this discussion as Correct Answer, if it solves your problem.

Regards,

Jagan.

Re: prior 4 & 52 week

Mon, 09 Jul 2012 15:16:40 GMT

Would you happen to still have the qvw file and be abe to re attach it to this discussion, but one that allows me to open in personal edition of Qlikview?

Thanks