Hi Gurus, I have a pivot chart with 2 dimensions CUSTOMER, WEEKNUMBER and an expression SUM(SALES_BOXES), something like this:
CUSTOMER
WEEK NUMBER
20
21
22
23
24
25
26
27
28
29
30
31
32
21085
0
0
40
-20
0
0
0
0
0
0
0
0
0
21086
0
0
50
89
0
103
0
0
0
310
0
0
0
21088
0
0
0
72
26
6
0
0
47
101
2
0
115
21080
0
0
13
0
11
0
20
0
0
0
66
20
62
21081
0
12
0
22
22
0
10
21
0
11
30
0
10
21082
0
18
0
5
20
0
26
25
26
0
20
11
0
21083
33
-18
0
25
0
32
0
0
15
0
0
45
0
I want to calculate Fractile 0.75 each customer but I have an issue if I compare the percentile value (fractile) in MS Excel is not the same value.
For Example the customer 21088 in excel the result is 47but in qlikview is 86.5, I think Excel is using all the weeks not nulls and nulls (13) but qlikview is just using NOT NULL (7). This is the expression:
