Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thx Abhinav,
i've tried that in the first way,
but in my chart, dimension is also static.
Can you try this
= count(Aggr(count(Distinct [Entry ID Extra]),Week))
Thx Jay, but it is far from correct
Is it possible to attach a sample file. It will help in troubleshooting the issue.