topic Re: Create calculated column of two tables inside script in QlikView

Create calculated column of two tables inside script

Mon, 18 Mar 2013 12:27:23 GMT

Hello community,

This question is related to my previous post:

I have two tables with the following (simplified) structure:

DataTable:

LOAD

...

Amount,

InvoiceCurrency,

if(NOT Wildmatch(InvoiceCurrency,'EUR'), InvoiceCurrency&'-'&CutoffDate,'EUR') AS ComboCurrDate

...

EcbTable:

LOAD

ComboCurrDate,

ECBrate

So the tables are linked through the ComboCurrDate column.

I want to add a column for EurAmount so that I can use this field in set analysis and other scenarios.

Right now I use this statement to calculate the EurAmount outside my script:

if(NOT Wildmatch(InvoiceCurrency,'EUR'), (Amount / (1 * ECBrate)),Amount)

What do I need to do to create this calculated column? Create a third table, use a join - do I need a real key field?

I hope you can help me out here.

thank you.

Mon, 18 Mar 2013 12:52:51 GMT

DataTable:

LOAD

...

Amount,

InvoiceCurrency,

if(NOT Wildmatch(InvoiceCurrency,'EUR'), InvoiceCurrency&'-'&CutoffDate,'EUR') AS ComboCurrDate,

' ' as EurAmount

...

EcbTable:

LOAD

ComboCurrDate,

ECBrate

Mon, 18 Mar 2013 13:09:48 GMT

I don't get it

This way I still have to use the if statement in every expression, don't I?