Include Statement

[NavinReddy]

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

[julian_rodriguez]

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

[swuehl]

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.

[NavinReddy]

Hi Swuehl,

i tried with excel its giving some error

can you share to me if you have any sample apps

Best regards

Niranjan

[NavinReddy]

Hi,

while loading its giving some error

is that syntax correct

Thanks

Niranjan

[swuehl · Accepted solution]

Attached a sample QVW and Excel file

[NavinReddy]

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

[NavinReddy]

Guys any suggestions

[swuehl]

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

The Magic of Variables

Attaching also a modified sample.