topic Re: How to show report Weekly basis in QlikView

How to show report Weekly basis

narender123 — Wed, 26 Jun 2013 07:04:22 GMT

Hi Team,

i want to make a weekly report for revenue collection for current week of this year Vs last year for current week.Please guide me .

WEEKLY REVENUE COLLECTION
14^th June	15^th June	16^th June	17^th June	18^th June	19^th June	20^th June
$33,252.03	$2,105.21	$149.14	$56,502.98	$51,347.33	$69,520.75	$76,880.61
TOTAL REVENUE COLLECTION						$2,76,758.05
TOTAL REVENUE COLLECTION 2012						$2,64,304.95

Thanks in advance.

Narender

Re: How to show report Weekly basis

narender123 — Wed, 26 Jun 2013 10:42:40 GMT

Hi All,

Its first time that i am handling with weekly report.please give me some idea??

Re: How to show report Weekly basis

narender123 — Wed, 26 Jun 2013 12:13:05 GMT

Hi Team,

Is it possible to show report like this ,if yes then some one could tell me please

Thanks in advance.

Re: How to show report Weekly basis

tresB — Wed, 26 Jun 2013 12:39:27 GMT

If I have understood your requirement, try something like this:

Current Week Rev = Sum (If (Week(DateField)=$(vCurrWeek), AmountField) , where vCurrWeek=Week(Max(YourDateField)

Prev. Year Same Week Rev = Sum (If (Week(DateField)=$(vCurrWeek) AND Year(DateField) = Year(Max(YourDateField) - 1, AmountField)

The same logic can be implemented using Set Analysis.

Thanks.

Re: How to show report Weekly basis

narender123 — Wed, 26 Jun 2013 12:52:42 GMT

Thanks tresesko and er. Mohit.

Could you teel me how can i show date in dimention like

15 jane 16 june or can say 15/01/2013 16/06/2013 ..............

sum(tax) Sum(tax) ................

Thanks u very much..

Re: How to show report Weekly basis

narender123 — Wed, 26 Jun 2013 13:21:12 GMT

Thanks tresesko,

Prev. Year Same Week Rev = Sum (If (Week(DateField)=$(vCurrWeek) ANDYear(DateField) = Year(Max(YourDateField) - 1, AmountField) is not working .I thing the problen is in bracks???

Re: How to show report Weekly basis

tresB — Wed, 26 Jun 2013 13:24:17 GMT

Yes,

Year(Max(YourDateField)....... should be

Year(Max(YourDateField) )

Re: How to show report Weekly basis

Wed, 26 Jun 2013 13:36:56 GMT

Hi Narender,

Don't use a calculated condition here. create a calendar table with the week field and use it in the application.

Re: How to show report Weekly basis

narender123 — Wed, 26 Jun 2013 13:43:14 GMT

Thanks Sampath . I have calculated it in my script but the problem is not regarding with it.

The problem is with previous year sum.