topic Re: Use an IF statment store in table on script in QlikView

Use an IF statment store in table on script

Mon, 02 Jun 2014 16:51:07 GMT

Hello,

I want to use an if statment store in a table in a load script.

Example :

My Table Source

ID | IFSTATMENT

1 IF(CODE=C2,'A','B')

2 IF(CODE=C1,'C','D')

Target TABLE

CODE | ID | VALEUR

C2 1 A

C2 2 D

How generate the target table ?

I have tryed with an Lookup function but the result is

CODE | ID | VALEUR

C2 1 IF(CODE=C2,'A','B')

C2 2 IF(CODE=C1,'C','D')

What is the syntax for QLIKVIEW interpreter the if statment ?

Thanks !

Re: Use an IF statment store in table on script

marcus_sommer — Tue, 03 Jun 2014 09:24:00 GMT

What is the aim for the target-table? What do you want to do?

- Marcus

Re: Use an IF statment store in table on script

Tue, 03 Jun 2014 09:36:49 GMT

In fact, I recovers the rules of calculation of indicators from a configuration file because the rules change regularly.

ex : Monday : If(Code='A',1,0)

Thursday If(Code='A',5,0)

And i want to generate automatically the rules in my Load Script

Re: Use an IF statment store in table on script

MayilVahanan — Tue, 03 Jun 2014 09:39:50 GMT

Try with Mapping and ApplyMap concept for solve your requirement

Re: Use an IF statment store in table on script

marcus_sommer — Tue, 03 Jun 2014 09:41:28 GMT

But you have already this if you loaded your "My Table Source".

Re: Use an IF statment store in table on script

Tue, 03 Jun 2014 09:44:14 GMT

try this:

iftbl:

Mapping LOAD * INLINE [

ID,F1

1,"IF(CODE=C2,'A','B')"

2,"IF(CODE=C1,'C','D')"

];

LOAD *, Evaluate( ApplyMap('iftbl',ID)) as ifexpr;

load * INLINE [

CODE, ID

C2,1

C2,2

];

Re: Use an IF statment store in table on script

Tue, 03 Jun 2014 09:46:43 GMT

"My Source Table" is loaded with values of config file !

I want execute the IF statement on the load of my Target table!

Re: Use an IF statment store in table on script

Tue, 03 Jun 2014 09:50:15 GMT

Thanks Dariusz it works !!!

Re: Use an IF statment store in table on script

Tue, 03 Jun 2014 09:56:19 GMT