Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

aashish591
New Contributor II

how to use $(include) for expression.

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

1 Solution

Accepted Solutions
sushil353
Honored Contributor II

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

is it what you are looking for..

PFA

HTH

Sushil

3 Replies
er_mohit
Honored Contributor II

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

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

jvitantonio
Valued Contributor III

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

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.

sushil353
Honored Contributor II

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

is it what you are looking for..

PFA

HTH

Sushil

Community Browser