Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variable Expression not working in HTML Report

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

1 Solution

Accepted Solutions
sushil353
Master II
Master II

Try Adding "=" sign in variable value:  =Count(Distinct(@OrderId))

HTH

View solution in original post

1 Reply
sushil353
Master II
Master II

Try Adding "=" sign in variable value:  =Count(Distinct(@OrderId))

HTH