[ASK] Set Analysis Full Week Value by Month

[#1]

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

[#2]

Thx Ajay, it really helps..

i've tried the back-end solution with my data model, and value is count(sales)..and your example is using sum(Amount)

in my data model it is shows incorrect values.

i change the expression to =count(Aggr(count( [Entry ID Extra]),Week))

where is my mistake?

Btw, my dimension is group dimension drill-down Year-Month-Week

[#3]

Thx Abhinav,

i've tried that in the first way,

but in my chart, dimension is also static.

[#4]

Can you try this

= count(Aggr(count(Distinct [Entry ID Extra]),Week))

[#5]

Thx Jay, but it is far from correct

[#6]

Is it possible to attach a sample file. It will help in troubleshooting the issue.