topic Re: how to use $(include) for expression. in QlikView

how to use $(include) for expression.

Anonymous — Wed, 29 May 2013 09:43:15 GMT

Hi experts,

I have an application, in which i have so many expressions used ...

we can assign those expression to variables and use those variables instead of expression..

My question is .. is it possible to save all those expression in one .csv or txt file and use them using $(include) command..

Please share your views.. and if possible please share any sample application.

Thanks

Aashish

Re: how to use $(include) for expression.

er_mohit — Wed, 29 May 2013 09:51:07 GMT

You have to do it in that application it quite simple to add the expression in the form of varirable rather then to store in txt file its to complicated

like the expression i have mde is too long and use 8 times i can't write that code too much

so, i made a variable like v1

for making variable press ctrl+alt+v

add variable v1 and in defination

write your expression with equal sign

then ok

and use that variable in your expression

it helps you

Re: how to use $(include) for expression.

jvitantonio — Wed, 29 May 2013 09:52:11 GMT

Yes you can. the include option will include the file with all the text in it. Save in a csv file all your expresions like:

SET vVar1 = sum(A);

SET vVar2 = sum(B);

etc

then add your file and use the variables in the expressions.

Re: how to use $(include) for expression.

sushil353 — Wed, 29 May 2013 10:32:25 GMT

is it what you are looking for..

PFA

HTH

Sushil