Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Expression eror in Pick match

Hi , I am new to Qlik Sense as i want to create a calculation for each field and i need to take it as a table when i am trying to do that with pick match i am getting an expression error

first i created a valuelist of 5801,5802,5803,58033

Now i am trying create a measure field to match that fields,Here i am facing a problem can u plzz help me to solve these

valuelist.JPG

I have show my report as below

Report.JPG

13 Replies
rubenmarin

Still needs to close Match:

Pick(Match(ValueList('5801','5802','5803','58033'),'5801','5802','5803','58033'),

  Count(distinct total [EMployeeID-MF]),

  Sum(total [Hours-MF]),

  Sum(total [Total-MF]),

  Sum(total [Total-MF])

)

Anonymous
Not applicable
Author

But when i am trying to take the measure it is showing as internal engine error

Anonymous
Not applicable
Author

Thank you Ruben problem solved

rubenmarin

I will need to tale a look at a sample, I have used this approach in many situations and I haven't found that message.