A function into a variable

[#1]

Hello everyone,

I'm french and i'm working at present in a company for a work experience placement. They put me on a computer and i'm using for the first time Qlikview. I have to make a programme which going to classify by order of urgency products to make. Somewherre, i make a dynamic crossed board and in this one, i add a calculated dimension to transform a basic date into a date with this syntax : 20**/W** ( W = week ) thanks to this function, this is my code ( don't worry about what is inside ) : =WeekName( if( Date_Liss>4000,Date_Liss+3*7,Sem_Mont) ).

But I wonder if it's possible to write it in the script as a variable and call it in my board with ( $ ) for example ( sorry I'm a real beginner ).

Thanks for your herlp.

[#2]

yes but once again I've a matter of " Overtaking of the assigned memory "

[ashwanin]

Hi Jeremy,

i dont know why you are getting this error.

Do one thing calculate this formula in script

in script add below

WeekName( if(Date_Liss>4000,Date_Liss+3*7,Sem_Mont)) as varSem_Month,

and check you are getting the same error?

[#4]

I think I can't write it in the script because variable Date_Liss and Sem_mont are variables in two differents field so i don't know how and where write it.

We agree :

1- Ctrl+Alt+V : Name : SEM_MONT  Expression : WeekName( if( Date_Liss>4000,Date_Liss+3*7,Sem_Mont) )

2- Board Properties : Add a calculated dimension : =$([SEM_MONT])

3- Apply

That's right ?