Product() excel function

[Gowtham174]

Hi Everyone,

Could you please help me on the below product function which is there in excel.

Need to show expected result in qliksense table 

Tried with below not able to get:

exp(sum
({<Date={">=$(=Date(Yearstart(vToDate))) <=$(=Date(vToDate))"}>}Aggr(nodistinct
below(
rangesum(below(log(sum({<Date={">=$(=Date(Yearstart(vToDate))) <=$(=Date(vToDate))"}>}Value))
,0,NoOfRows())) ,1,NoOfRows()),Date)))

Date	Value	Expected
2-Jan	100.91%	87.49%
3-Jan	99.83%	86.70%
6-Jan	99.91%	86.85%
7-Jan	100.27%	86.93%
8-Jan	100.32%	86.70%
9-Jan	100.50%	86.42%
10-Jan	100.14%	85.99%
13-Jan	100.12%	85.87%
14-Jan	100.10%	85.76%
15-Jan	99.97%	85.67%
16-Jan	100.23%	85.69%
17-Jan	100.35%	85.50%
20-Jan	100.01%	85.20%
21-Jan	99.84%	85.19%
22-Jan	100.19%	85.33%
23-Jan	99.96%	85.17%
24-Jan	100.21%	85.21%
27-Jan	99.05%	85.03%
28-Jan	100.42%	85.84%
29-Jan	100.11%	85.48%
30-Jan	99.61%	85.38%
31-Jan	99.04%	85.72%
3-Feb	100.19%	86.55%
4-Feb	101.08%	86.39%
5-Feb	100.57%	85.46%
6-Feb	100.58%	84.98%
7-Feb	99.92%	84.49%
10-Feb	100.44%	84.56%
11-Feb	100.27%	84.19%
12-Feb	100.64%	83.96%
13-Feb	100.07%	83.42%
14-Feb	100.07%	83.37%
17-Feb	100.09%	83.31%
18-Feb	99.97%	83.24%
19-Feb	100.49%	83.27%
20-Feb	99.76%	82.86%
21-Feb	99.38%	83.06%
24-Feb	98.25%	83.58%
25-Feb	98.69%	85.07%
26-Feb	99.61%	86.20%
27-Feb	97.83%	86.54%
28-Feb	98.32%	88.46%
2-Mar	100.48%	89.97%
3-Mar	99.52%	89.54%
4-Mar	101.13%	89.98%
5-Mar	99.10%	88.97%
6-Mar	99.36%	89.78%
9-Mar	97.06%	90.36%
10-Mar	101.12%	93.10%
11-Mar	99.05%	92.07%
12-Mar	97.64%	92.95%
13-Mar	100.87%	95.19%
16-Mar	98.26%	94.37%
18-Mar	98.57%	96.05%
19-Mar	100.67%	97.44%
20-Mar	101.00%	96.79%
23-Mar	99.56%	95.83%
24-Mar	100.17%	96.25%
25-Mar	99.44%	96.09%
26-Mar	99.76%	96.63%
27-Mar	99.61%	96.86%
30-Mar	100.52%	97.24%
31-Mar	99.78%	96.74%
1-Apr	100.48%	96.95%
2-Apr	100.07%	96.49%
3-Apr	100.35%	96.42%
6-Apr	99.46%	96.08%
7-Apr	99.26%	96.59%
8-Apr	100.00%	97.31%
9-Apr	99.76%	97.31%
14-Apr	99.72%	97.55%
15-Apr	100.74%	97.82%
16-Apr	100.20%	97.10%
17-Apr	99.52%	96.90%
20-Apr	100.16%	97.37%
21-Apr	100.56%	97.21%
22-Apr	99.86%	96.66%
23-Apr	99.77%	96.80%
24-Apr	100.19%	97.02%
27-Apr	99.37%	96.83%
28-Apr	99.80%	97.45%
29-Apr	99.59%	97.65%
30-Apr	100.14%	98.05%
5-May	100.76%	97.91%
6-May	100.12%	97.17%
7-May	99.96%	97.06%
11-May	99.37%	97.10%
12-May	100.21%	97.72%
13-May	100.52%	97.51%
14-May	100.35%	97.00%
15-May	99.93%	96.67%
18-May	98.75%	96.74%
19-May	99.62%	97.96%
20-May	99.99%	98.34%
22-May	100.76%	98.35%
25-May	99.77%	97.60%
26-May	98.80%	97.83%
27-May	99.98%	99.02%
28-May	99.60%	99.03%
29-May	100.38%	99.43%
2-Jun	98.52%	99.06%
3-Jun	98.98%	100.54%
4-Jun	99.62%	101.58%
5-Jun	98.94%	101.97%
8-Jun	99.91%	103.06%
9-Jun	100.46%	103.15%
10-Jun	100.49%	102.69%
11-Jun	102.12%	102.18%
12-Jun	100.18%	100.06%
15-Jun	100.06%	99.88%
16-Jun	99.17%	99.82%
17-Jun	100.10%	100.66%
18-Jun	100.40%	100.55%
19-Jun	99.99%	100.15%
22-Jun	100.03%	100.16%
23-Jun	99.48%	100.13%
24-Jun	100.75%	100.65%
25-Jun	100.19%	99.90%
26-Jun	100.29%	99.72%
29-Jun	99.89%	99.43%
30-Jun	99.74%	99.54%
1-Jul	99.66%	99.80%
2-Jul	99.88%	100.14%
3-Jul	100.01%	100.26%
6-Jul	99.55%	100.25%
7-Jul	100.31%	100.71%
8-Jul	100.02%	100.40%
9-Jul	100.41%	100.38%
10-Jul	99.94%	99.97%
13-Jul	99.55%	100.03%
15-Jul	99.78%	100.49%
16-Jul	100.32%	100.71%
17-Jul	99.89%	100.39%
20-Jul	99.89%	100.50%
21-Jul	99.85%	100.61%
22-Jul	100.22%	100.76%
23-Jul	100.07%	100.54%
24-Jul	100.04%	100.48%
27-Jul	100.03%	100.44%
28-Jul	100.13%	100.41%
29-Jul	100.00%	100.29%
30-Jul	100.55%	100.29%
31-Jul	99.95%	99.74%
4-Aug	99.90%	99.79%
5-Aug	99.72%	99.89%
6-Aug	100.21%	100.17%
7-Aug	99.71%	99.96%
10-Aug	99.91%	100.25%
11-Aug	99.13%	100.34%
12-Aug	99.83%	101.22%
13-Aug	99.68%	101.39%
14-Aug	100.28%	101.72%
17-Aug	100.39%	101.43%
18-Aug	100.36%	101.04%
19-Aug	99.83%	100.68%
20-Aug	100.27%	100.85%
21-Aug	99.95%	100.58%
24-Aug	99.96%	100.63%
25-Aug	99.62%	100.66%
26-Aug	99.91%	101.05%
27-Aug	99.88%	101.14%
28-Aug	100.49%	101.26%
31-Aug	100.13%	100.76%
1-Sep	100.10%	100.63%
2-Sep	100.03%	100.53%
3-Sep	100.12%	100.49%
4-Sep	99.72%	100.38%
7-Sep	99.79%	100.66%
8-Sep	99.97%	100.87%
9-Sep	100.09%	100.90%
10-Sep	99.84%	100.81%
11-Sep	100.40%	100.97%
14-Sep	100.09%	100.57%
15-Sep	99.92%	100.47%
16-Sep	99.76%	100.55%
17-Sep	100.34%	100.79%
18-Sep	99.88%	100.45%
21-Sep	99.99%	100.57%
22-Sep	99.77%	100.59%
23-Sep	99.46%	100.82%
24-Sep	99.99%	101.36%
25-Sep	100.03%	101.37%
28-Sep	100.10%	101.34%
29-Sep	100.45%	101.24%
30-Sep	99.85%	100.78%
1-Oct	100.27%	100.93%
2-Oct	99.82%	100.66%
5-Oct	99.82%	100.84%
6-Oct	99.78%	101.02%
7-Oct	100.02%	101.25%
8-Oct	100.14%	101.23%
9-Oct	100.34%	101.09%
12-Oct	99.90%	100.74%
13-Oct	100.10%	100.85%
14-Oct	100.09%	100.74%
15-Oct	100.07%	100.65%
16-Oct	100.06%	100.59%
19-Oct	99.87%	100.53%
20-Oct	100.00%	100.66%
21-Oct	99.95%	100.66%
22-Oct	99.64%	100.71%
23-Oct	100.09%	101.08%
27-Oct	100.37%	100.98%
28-Oct	99.76%	100.61%
29-Oct	99.90%	100.86%
30-Oct	99.77%	100.96%
2-Nov	100.10%	101.20%
3-Nov	99.95%	101.10%
4-Nov	100.73%	101.15%
5-Nov	100.17%	100.42%
6-Nov	99.84%	100.25%
9-Nov	98.84%	100.41%
10-Nov	99.53%	101.59%
12-Nov	100.38%	102.06%
13-Nov	100.20%	101.68%
16-Nov	100.17%	101.48%
17-Nov	100.09%	101.31%
18-Nov	99.99%	101.22%
19-Nov	100.07%	101.23%
20-Nov	100.20%	101.16%
23-Nov	99.83%	100.96%
24-Nov	100.18%	101.13%
25-Nov	100.10%	100.94%
26-Nov	100.09%	100.84%
27-Nov	100.12%	100.75%
30-Nov	99.86%	100.63%
1-Dec	99.82%	100.77%
2-Dec	100.03%	100.95%
3-Dec	100.30%	100.93%
4-Dec	100.05%	100.62%
7-Dec	100.20%	100.57%
8-Dec	100.07%	100.37%
9-Dec	99.91%	100.30%
10-Dec	100.29%	100.39%
11-Dec	100.10%	100.10%

Thank you from your time in advance.

Thanks,

Gowtham

[Anil_Babu_Samineni]

I would suggest from next time, Please post as in excel rather copy paste to avoid too much space. Perhaps this? If not, Please explain the logic. I predict that you are using pivot table since I can see Below() function used..

rangesum(
below(
log(
sum({<Date={">=$(=Date(Yearstart(vToDate))) <=$(=Date(vToDate))"}>}Value)
)
,0,Rowno(TOTAL))
)