topic Re: How to write an expression that involved different fields of different tables at different level in QlikView

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

Mattia — Fri, 22 Nov 2019 10:45:53 GMT

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

Re: How to write an expression that involved different fields of different tables at different level

Taoufiq_Zarra — Fri, 22 Nov 2019 14:30:18 GMT

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

Re: How to write an expression that involved different fields of different tables at different level

Mattia — Fri, 22 Nov 2019 14:46:48 GMT

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

Re: How to write an expression that involved different fields of different tables at different level

Taoufiq_Zarra — Fri, 22 Nov 2019 15:24:40 GMT

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.

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

Re: How to write an expression that involved different fields of different tables at different level

Brett_Bleess — Thu, 05 Dec 2019 19:34:03 GMT

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