Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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