Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

aryanreddy
New Contributor II

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
undergrinder
Valued Contributor II

Re: Expression eror in Pick match

Hi Aryan,

I think the problem may be at the ValueList function, try define a column instead of.

pick(match([column], ... , .... , ...),if......

G.

MVP
MVP

Re: Expression eror in Pick match

I think there are multiple problems here... would you be able to share your expression as text?

gngijben
New Contributor III

Re: Expression eror in Pick match

I think you shouldn't use the PICK() function here, but just use a nested IF instead.

So IF(Valuelist(a,b,c,d) =a, <expression>,

     IF(Valuelist(a,b,c,d) = b, <expression>, etc))

rajeshthakur292
Contributor II

Re: Expression eror in Pick match

Please try -

pick(match(valuelist(5801,5802,5803,58033),5801,5802,5803,58033)

,Sum({<[F/I] = {'F'}>}FieldName)

,Sum({<[F/I] = {'F'}>}FieldName)

,Sum({<[F/I] = {'F'}>}FieldName)+Sum({<[F/I] = {'F'}>}FieldName)+Sum({<[F/I] = {'F'}>}FieldName)

,Sum({<[F/I] = {'F'}>}FieldName)+Sum({<[F/I] = {'F'}>}FieldName)+Sum({<[F/I] = {'F'}>}FieldName)

)

aryanreddy
New Contributor II

Re: Expression eror in Pick match

When i add the Measure it is showing as Internal Engine error

aryanreddy
New Contributor II

Re: Expression eror in Pick match

When i am adding the measure in Pivot table i  am getting an internal engine error

aryanreddy
New Contributor II

Re: Expression eror in Pick 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])))

Re: Expression eror in Pick match

Hi aryan, at first sight i see two 2 things:

- Match should be closed after 58033

- Sum inside of sum: use RangeSum(Sum(), Sum()...) instead, or remove the outer sum, in this case seems it's not needed

aryanreddy
New Contributor II

Re: Expression eror in Pick match

I changed the formula, i wrote new formula above