topic Re: Evaluate() in QlikView

Evaluate()

rudywelvaert — Tue, 07 Jul 2015 08:22:39 GMT

Hi,

In my script I use this code

SET Lang= '$(Teamleader_Lang)';
LET MonthNames = Evaluate(If('$(Lang)' = 'F','jan;fév;mar;avr;mai;jun;jul;aoû;sep;oct;nov;déc', 'Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'));

I get this error:

Error: Error in expression:

EVALUATE is not a valid function

I thought Evaluate() is a valid function is script. How can this be? Is there an alternative?

It doesnt change a thing when I use:

SET MonthNames = Evaluate(If('$(Lang)' = 'F','jan;fév;mar;avr;mai;jun;jul;aoû;sep;oct;nov;déc', 'Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'));

Thanks

Re: Evaluate()

Gabriel — Tue, 07 Jul 2015 15:40:21 GMT

Hi,

What are you trying to achieve?

Evaluate might not be the right function to use here.

May be remove the Evaluate function and run the script

Re: Evaluate()

alexandros17 — Tue, 07 Jul 2015 15:42:49 GMT

There is a good example given from Qlik to manage MultiLanguage documents:

Re: Evaluate()

settu_periasamy — Tue, 07 Jul 2015 17:16:02 GMT

Hi,

May be you want like this?

//SET MonthNames='ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic';
SET DayNames='lun;mar;mié;jue;vie;sáb;dom';


LET Teamleader_Lang='F';
SET Lang= '$(Teamleader_Lang)';
if(Lang='F') then
  SET MonthNames='jan;fév;mar;avr;mai;jun;jul;aoû;sep;oct;nov;déc';
ELSE
  SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec');
ENDIF

Re: Evaluate()

rudywelvaert — Mon, 23 Nov 2015 10:37:17 GMT

Hi Settu,

This I tried, but it didn't work. MonthNames is a system variable, it doesn't react the same way as custom variables.

But I have found a work around:

SET MonthNamesN='jan','feb','mrt','apr','mei','jun','jul','aug','sep','okt','nov','dec';
SET MonthNamesF='jan','fév','mar','avr','mai','jun','jul','aôu','sep','oct','nov','déc';

=If($(vLanguage)='F',Pick(Month(Month_From),$(MonthNamesF)),Pick(Month(Month_From),$(MonthNamesN))) & ' ' & Year(Month_From)