Pick match function concern

zhaohaifeng — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Below case need your help. I have attached the Qvf and source file we used.

Now we want to achieve below,

when select MAT the value should be all the years sales based on Year deimension;

when select Monthly the value should be the sales in the past two years based on YearMonth dimension.

When select Qtr the value should be sales in the past years based on YearQtr dimension;

When select YTD the value should be sales in the Past-3/Past-6/YTD sales based on GrowthTrending dimension.

so we used pick/match to achieve.

For below screenshot,

For part1 chart can get the correct num, but we used same logic for part3 pivot table, then for MAT/QTR/Monthly the num is three times than chart correct num, and also for YTD, many times than correct num;

So for pick match function, any different for chart and table? Also attached the Qvf and excel. Thanks in advance!

Best Regards,

Haifeng

topic Pick match function concern in QlikView

Pick match function concern