topic condition to assign a variable in QlikView

condition to assign a variable

Fri, 28 Jan 2011 19:22:39 GMT

Hi togehter,

how can i set a variable (myVar) during the load process of my csv, if the condition (see below) is true ?
Thank you for any help

************************

MyTable:
LOAD Datum,
if(Datum = '07.01.2011', myVar = 'true', Datum) as DatumCheck,
Impressions

FROM
test1.csv (txt, codepage is 1252, embedded labels, delimiter is ';', msq);

*************************

condition to assign a variable

Fri, 28 Jan 2011 19:34:23 GMT

Hi,

For set a variable, you need the command SET or LET.

I recommend creating a field in the table.

You try this.



MyTable:
LOAD Datum,
 if(Datum = '07.01.2011', 1, 0) as FlgTest,
 Impressions
FROM
test1.csv (txt, codepage is 1252, embedded labels, delimiter is ';', msq);

condition to assign a variable

Fri, 28 Jan 2011 21:05:54 GMT

Hello Tonial,

thank you for your answer. But how can I now send an email alert with QV without a variable?

Thank you!

Yours sincerely,

condition to assign a variable

Sun, 30 Jan 2011 00:00:46 GMT

Hi together,

otherwise there is no other way to set variables while loading ? I therefore need a variable
because I want to trigger an email if the records contain old values.

Best regards

condition to assign a variable

Mon, 31 Jan 2011 11:17:10 GMT

You can try this code after previous code:


Tmp_Table:
LOAD distinct FlgTest as TmpFlgTeste
resident MyTable
where FlgTest = 1;
LET vMyVar = Peek('TmpFlgTeste');

condition to assign a variable

Tue, 01 Feb 2011 16:52:10 GMT

Hi Mr. tonial.

thats it ! Thank you very much !

Best Regards