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

Help With Expression

Hi Guy's

I am trying to create a straight table with results in the expression total at the top. I do not know where to put aggr or my sum values for it to display. Below is the calculation

[WIS - Curing Bin] -

([WIS - Curing Bin]/[Sample Wis Mass])*([Sample Dis Mass]*(100-[Sample DIS Moisture]))/(100-1.5)

/ [WIS - Curing Bin]

* 100

Thank you in advance

Labels (1)
1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Your expression doesn't contain an aggregation function so try this first:

sum(

[WIS - Curing Bin] -

([WIS - Curing Bin]/[Sample Wis Mass])*([Sample Dis Mass]*(100-[Sample DIS Moisture]))/(100-1.5)

/ [WIS - Curing Bin]

* 100

)


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Your expression doesn't contain an aggregation function so try this first:

sum(

[WIS - Curing Bin] -

([WIS - Curing Bin]/[Sample Wis Mass])*([Sample Dis Mass]*(100-[Sample DIS Moisture]))/(100-1.5)

/ [WIS - Curing Bin]

* 100

)


talk is cheap, supply exceeds demand