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: 
Karahs
Partner - Creator
Partner - Creator

Expression Issue

Hello Everyone,

I have a Pick(Match()) expression which i am using in a Pivot Table wherein i get all my values correctly, the same i want to use in a Combo Chart. But since i have used Pick(Match()) chart shows blank value. I want values to display without doing any selction. I hope i am clear with the question, also attaching the result which i am getting:

Pivot TablePivot Table

Combo ChartCombo Chart

Expected ResultExpected Result

Expression:

=Pick(Match(_StoreSortOrder,'1','2','3'),

Date(Opening_Date),
num(sum([Days of Operations in the month]),vNumFormat),
Num(sum([No. of Tickets (000)] * 1000)/Sum([Days of Operations in the month]),vNumFormat))

Thanks,

Labels (2)
1 Reply
tresesco
MVP
MVP

Are you using the same dimensions in combo chart as in pivot? Perhaps not. Could you share your sample app?