Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Mattia
Creator II
Creator II

How to write an expression that involved different fields of different tables at different levels?

Hi to everyone,

i need help to solve a complex (for me) problem.

i have 3 tables: AMB2, AMB1 and COM.

AMB2 and AMB1 have three key fields, AMB1 and COM one key field, AMB2 and COM no key field.

I need to write an expression in the script that involve fields of tables AMB2 and COM.

Which function could i use?  I've tried with ApplyMap but something don't work, is there a different option to do this?

Thanks,

Mattia

Labels (1)
4 Replies
Taoufiq_Zarra
Master II
Master II

Hi Mattia,

What is the purpose of the expression? more detail (better an extract from your loading script).

otherwise, if you don't penalize the performance of your dashboard, you can use the Set Analysis functions in the sheet, it's very powerful.


Taoufiq

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Mattia
Creator II
Creator II
Author

Hi Taoufiq,

thanks for the reply and the suggest. Unfortunately, i'm a newbie and i'am a controller, so i'm in trouble with this thing.

Attached is a sample data file with 3 tables in the script.

The output i want to obtain is in the script as comment.

Thanks,

Mattia

Taoufiq_Zarra
Master II
Master II

Hi,


I haven't found anything that can block you.


But one thing you need to review your data model, I deleted the $Syn (concatenate the keys in one), but it may change depending on your context.

datt.PNG

otherwise for outputs just put if...else in the script like for example if(WildMatch(REG,'9*') or WildMatch(REG,'8*'),'BDG',if(REG<>'030','EXTRAREG',.........)) as NewREG,

Taoufiq

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Brett_Bleess
Support (Former)
Support (Former)

Mattia, did Taoufiq's last post get you what you needed on this one?  If so, as always, do not forget to come back and use the Accept as Solution button on the post from him to give him credit for the assistance and to let other Community Members know it worked.  If you are still working on things, please leave on update with what you still need.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.