Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I have show my report as below
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])
)
But when i am trying to take the measure it is showing as internal engine error
Thank you Ruben problem solved
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.