Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
padma588
Contributor
Contributor

Monthly value at week level

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.

5 Replies
satyadev_j
Specialist
Specialist

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;

parthiband
Partner
Partner

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?

padma588
Contributor
Contributor
Author

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.

parthiband
Partner
Partner

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

padma588
Contributor
Contributor
Author

Hi Parthiban,

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