Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Highlighted
ccarlock12
New Contributor II

How do I get a total (Calculated Estimate Margin) to appear with totals?

I have a Sales Order Sheet set up and I am getting information totaling for my Sales Order values and Estimate Costs. But what is not showing up is the calculated result of my Calculated Estimate Margin. They appear line by line not problem, but I have checked off under Chart Properties/Expressions/Total Mode=Expression Total.

I have attached screen grabs of my sheet, chart properties and expression definition. Any help to have the total result appear under Cal Estimate Margin would be greatly appreciated.

Tags (1)
1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

Re: How do I get a total (Calculated Estimate Margin) to appear with totals?

Not sure but try this? If not can you upload a sample app to work on?

Calculate %Estimate Margin

= Sum( (([So Value] -  [Est Cost])/ [So Value]))

7 Replies
Not applicable

Re: How do I get a total (Calculated Estimate Margin) to appear with totals?

Chris,

Expecting total for a percentage column is not possible in any of the charts. We can only calculate total for numbers or points.

Hope this helps

vishsaggi
Esteemed Contributor III

Re: How do I get a total (Calculated Estimate Margin) to appear with totals?

Not sure but try this? If not can you upload a sample app to work on?

Calculate %Estimate Margin

= Sum( (([So Value] -  [Est Cost])/ [So Value]))

ccarlock12
New Contributor II

Re: How do I get a total (Calculated Estimate Margin) to appear with totals?

Do I make this change in the expression edit (definition)?

vishsaggi
Esteemed Contributor III

Re: How do I get a total (Calculated Estimate Margin) to appear with totals?

Yes.

vishsaggi
Esteemed Contributor III

Re: How do I get a total (Calculated Estimate Margin) to appear with totals?

Did you try the expression? Is it working?

ccarlock12
New Contributor II

Re: How do I get a total (Calculated Estimate Margin) to appear with totals?

It is, Thank you. I would like to ask another question about creating a way in NPRINT for a word doc to show a report by subtotaling Monthly information. Would you be able to help, I can post a new question

vishsaggi
Esteemed Contributor III

Re: How do I get a total (Calculated Estimate Margin) to appear with totals?

Ahh! Not really expert in Nprinting. But would try, post it, some one else might help too.