Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Attached a sample QVW and Excel file
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
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.
Hi Swuehl,
i tried with excel its giving some error
can you share to me if you have any sample apps
Best regards
Niranjan
Hi,
while loading its giving some error
is that syntax correct
Thanks
Niranjan
Attached a sample QVW and Excel file
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
Guys any suggestions
See Henric's blog post for an introduction of using variables as expression:
Attaching also a modified sample.