Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Acquires Upsolver to Advance Iceberg Solutions: READ MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
xavieravinson
Contributor III
Contributor III
‎2019-03-17 02:23 AM

Issues in Pick Match function

Hello All,

 

I am using pick match function to show some measures. For Eg. Region is my dimension. One of my region doesn't have values for current year but it has values for previous year. In normal expression it showing values for previous year but in pick match it is not showing any values.

 

Please help me to solve this issue.

 

With Regards,

Xavier

Labels (3)
Labels
1,096 Views
0 Likes
4 Replies
VishalWaghole
Specialist II
Specialist II
‎2019-03-17 02:59 AM

Could you please share some sample data with your problem.
1,091 Views
0 Likes
Channa
Specialist III
Specialist III
‎2019-03-17 05:09 AM

try lookup or applyMap

Channa
1,081 Views
0 Likes
xavieravinson
Contributor III
Contributor III
‎2019-03-17 06:59 AM
Author

Hello All,

Attached the sample file. 

Want LY values in Pick Match.

With Regards,

Xavier

Preview file
9 KB
1,069 Views
0 Likes
xavieravinson
Contributor III
Contributor III
‎2019-03-17 06:59 AM
Author

In response to xavieravinson

Sample Application

Test App.qvw
1,068 Views
0 Likes