Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zhaohaifeng
Contributor III
Contributor III

Pick/ Match Concerns

Hi Folks,

Concerns regarding Pick match need your help.

Now we faced the challenge, See details as below:

Dimension:

Pick(match(GetFieldSelections(Periods),'Qtr','MAT','Monthly','YTD'

),

YearQtr,[Y e a r],YearMonth,Pastfield

)

Note:Passfield not associated with master table, other three dimension associated.

Measure:

Pick(match(GetFieldSelections(Periods),'MAT','Qtr','Monthly','YTD'),
num(sum(1),'#,##0'),
sum(2),
sum(3),
sum(4)).

In current case, we get the result as 1224, not 4; just we used Pastfield only, we can get the correct num 4, so this is my concern, why we cant get the correct num? Thanks in advance.

Best Regards,

Haifeng

2 Replies
big_dreams
Creator III
Creator III

Hi,

Since we are not aware of your data model ,structure so we are unable to why it is going wrong?

Can you share your qvf? or provide more details?

Regards,

zhaohaifeng
Contributor III
Contributor III

Thanks. let me attached the qvf.