Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zhaohaifeng
Contributor III
Contributor III

Data model Query

Hi Folks,


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,

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;

Part 2 pivot table set condition for MAT/Monthly/Qtr, then we can get the correct num ;

Part 4 pivot table set condition for YTD, then we can get the correct num;

So i think it's may be the data model issue for YTD part, but i dont find the solution. Please help to check. Thanks.

Mockup_.PNG

0 Replies