topic Include Statement in QlikView

Include Statement

NavinReddy — Fri, 21 Aug 2015 14:34:57 GMT

Dear experts,

LET vExp1="$(=count({<[Audit Rating]={'NI','Inad'}>}[Audit Report Number])/Count([Audit Report Number]))";

this expression i stored in notepad i have many repressions

if can use include statement im getting some error

can some can load thought notepad this expression into qlikview

if can i get sample app great help to me

Best Regards,

Niranjan

Re: Include Statement

julian_rodriguez — Fri, 21 Aug 2015 14:40:44 GMT

Hello Niranjan:

I think that the keyword "LET" is evaluating the expression before to assign the value to the variable.

Have you tried with "SET" instead "LET" ?

Regards

Re: Include Statement

swuehl — Fri, 21 Aug 2015 14:45:44 GMT

You can create an excel file with two columns, variable name and variable definition.

Then you can load the table in the script and loop over all records to create variables from the two fields.

There is an example in the HELP that demonstrates this approach.

Re: Include Statement

NavinReddy — Fri, 21 Aug 2015 15:10:08 GMT

Hi Swuehl,

i tried with excel its giving some error

can you share to me if you have any sample apps

Best regards

Niranjan

Re: Include Statement

NavinReddy — Fri, 21 Aug 2015 15:12:29 GMT

Hi,

while loading its giving some error

is that syntax correct

Thanks

Niranjan

Re: Include Statement

swuehl — Fri, 21 Aug 2015 17:55:24 GMT

Attached a sample QVW and Excel file

Re: Include Statement

NavinReddy — Fri, 21 Aug 2015 18:50:06 GMT

Hi Swuehl,

Thank you so much for your reply

in list box using this expression field how can show the value

this is problem im facing

vTest=sum({<Key = {"=sum(Sales)>0"}>} Value)

this way im passing the all expression to that variables ,i want to those variable into my Charts

if your previous app don't know how can use

Regards,

Niranjan

Re: Include Statement

NavinReddy — Sat, 22 Aug 2015 08:06:35 GMT

Guys any suggestions

Re: Include Statement

swuehl — Sat, 22 Aug 2015 08:46:23 GMT

See Henric's blog post for an introduction of using variables as expression:

The Magic of Variables

Attaching also a modified sample.