Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

[ASK] Set Analysis Full Week Value by Month

Hello qlikview,

if i want to show value by week with year and month selected, how to show full value if the week separate by 2 month?

Example :

A.

Selected Year : 2014

Selected Month : March

Result :

Week | Value

--------------------

9 | 24

10 | 521

11 | 64

12 | 85

13 | 361

B.

Selected Year : 2014

Selected Month : February

Result :

Week | Value

--------------------

5 | 24

6 | 521

7 | 64

8 | 85

9 | 361

Expected result :

Selected Year : 2014

Selected Month : March

Result :

Week | Value

--------------------

9 | 385

10 | 521

11 | 64

12 | 85

13 | 361

What i expected is i have value 385 when i select 2014 and March instead of 24.

How to do that?

Many thx

14 Replies
Not applicable
Author

anyone please?

Not applicable
Author

From a quick look, it seems like its working the way its supposed to work.

lets take

Feb 25,26,,27,28  and Mar 1,2,3

and these seven days are week 9. If you select

2014 and Mar you are essentially picking only 1,2,3 from Mar which is how it should be. It makes total sense.

Why should it include days from Feb when you select Mar.

This is common when weeks overlap with two months.

Not applicable
Author

i know it's really common, but the client really insist to.

So when i select 2014 and February, week 9 also view 385 as value.

is there any way out?

swuehl
MVP
MVP

Not really clear to me what you want.

Do you want the value 385 in week 9 in month Feb as well as in month Mar? Or only in one month? Then, which criteria do you use to assign a week to a given month when the week belongs to two? The month having at least 4 days of the week? The later month?

Not applicable
Author

what the client request is,

when a week split by current month and previous/next month, then this week still have show its full value.

Like first week and last week in January 2014, they split in December 2013 and Febrruary 2014..

but when i select 2014 and January, week 1 and week 5 still have to show they full value.

Yes, i want to show 385 in week 9 when i select 2014 and February, also when i select 2014 and March.

Thx before

Not applicable
Author

Ah. Understood.

Please check out the attached file. I created two fields OriginalAmount and Amount.

The Amount field works per your requirement. I did it in the back-end.

Hope it helps

Not applicable
Author

Many thx before Ajay,

nice solution and really helpfull.

But is there anyway to do it on the frond-end? with set analysis perhaps.


because in my case, value is not in the same table as date

Not applicable
Author

Sure. Attached with SET analysis example

Thanks

Not applicable
Author

Hi Rendi,

Here is how you can do it using set analysis. Hope this helps.