topic Re: Re: Monthly value at week level in QlikView

Monthly value at week level

Anonymous — Mon, 14 Jul 2014 08:59:33 GMT

Hi All,

I have a requirement to represent the weekly value( Value) at month level.

What i have done is , i have performed a Group by at the month level to get the monthly level Value(in the script).

But the challenge is to represent the monthly value at the Week level.( Image2), without using the Month, in the dimensions , because it messes up my other KPI's

So far I'm only able to represent it month wise( Image1)

As shown in image2

Week 18- Week 22- Month1

Week 23- Week 26 - Month 2

Week 27- Week 31- Month 3

Anyway I can get the Monthly value at week level?

Thanks in advance for your time and help.

Re: Monthly value at week level

Anonymous — Mon, 14 Jul 2014 09:19:14 GMT

Hi,

You can divide number of weeks in a month to convert monthly value into weekly. For example,

TableA:

Load

Month,

Monthly_Value

From <Table1>

Left Join

Load

Month,

Week

From <Table2>

TableB:

Load

Month,

Sum(Monthly_Value)/Count(Week) as Weekly_Value

Resident TableA

Group by Month;

Re: Monthly value at week level

parthiband — Mon, 14 Jul 2014 09:29:12 GMT

Sorry,

I need u to explain a bit more clearly.

U r having data in week level.

U want to show in month level or week level?

If week/Month, how u want it to get displayed?

Re: Re: Monthly value at week level

Anonymous — Mon, 14 Jul 2014 09:39:19 GMT

Hi Parthiban & Satyadev

I have the value at both month level and week level.

But the problem is I want to represent the month level data at week level.

To make it more clear.

Please see Image-3

Here 382,250 represents month1 value( Month 1 comprises of W44 to W48)

406950 represents month 2 value (W49 to W52).

Thanks again for your time.

Re: Re: Re: Monthly value at week level

parthiband — Mon, 14 Jul 2014 10:44:23 GMT

Hi Rajagopal,

If my assumption is right about your requirement, there's nothing to do with your data model whereas tricks will make it work.

Please find the attachment.

I'd did an sample based on my understanding.

Please revert me back if am wrong

Re: Re: Re: Monthly value at week level

Anonymous — Wed, 16 Jul 2014 08:35:46 GMT

Hi Parthiban,

Thanks a lot. I'm trying it out now. Will let you know if it worked.