Pick and Match

[ECEK]

Hello, Qlik Community,

I hope you are all doing well. 

I kindly ask for support in solving a Qlik Sense, Pick, and Match() formula issue. 

I have an Excel File that has 7 sheets...

I started my formula pick and match for the first sheet, and everything went well.

when I started using the same formula to access the data in the second sheet the result or returned data value wasn't accurate.. 
my question is, can I use the Pick(Match()) formula to access data in different sheets? 

My Formula:

sum(

pick(Match(Indicators,

'# of PoCs ',

‘# of ',

'# of ',

'# of ',

'# of ‘,

'# of’,

'# of of common areas '

),

if(([Bs.Status]= 'Completed' and [Reh]='Reh'), [Units]),

if([Bs.Status] = 'Completed', [SSBs.Number of IND]),

if(([Bs.Status]= 'Completed' and [Reh]=' Repair'), [Units]),

if([Bs.Status] = 'Completed', if([PWD]='yes',1,0)),

if(([Bs.Status] = 'Completed' and [GOZstatus]='signed'), 1,0),

if(([Bs.Status] = 'Completed' and [HLP]='Yes'), 1,0),

if([Area.Status] = 'Completed', [Area.Number]),))

when I added this line "if([Area.Status] = 'Completed', [Area.Number])" to access the data in different sheet.. the numbers returned wasn't right.

where is my fault? or its just the formula don't work this way?

[ajaykakkar93]

Hi,

Firstly, your expression has an extra comma at the end,
                if([Area.Status] = 'Completed', [Area.Number]),))

Secondly, I will need sample data to solve your issue

[ECEK]

Hello, 

Thank you for supporting me in this Qlik-related issue. I want to update you that I have solved the issue, but your interaction with my message is appreciated. 

I am new to Qlik Sense and would like to have some support to gain more knowledge and understanding about this tool. 

Best regards,

E.C.K