Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
All my expressions are imported from an excel spreadsheet as variables.
I am trying to use those variables in HTML report in Npritning but they not working!
Variable Name : vEx.Total.Orders
Variable Value : Count(Distinct(@OrderId))
When I use the same variable in QlikView Object then I use $(vEx.Total.Orders) in expression and it gives me total number of orders. which is working perfect.
But When I create HTML report in NPrinting like below
<html>
<body>
Total %%vEx.Total.Orders%% Orders Received Today
</Body>
</Html>
Then I don't get total number of order but instead I get following output.
today Count(Distinct(@OrderId)) total ordered received
Try Adding "=" sign in variable value: =Count(Distinct(@OrderId))
HTH