Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to sum the following equation ([VERVOER-TARIEF] + VERVOER)*[FAKTUUR MASSA]/1000
I have tried the regular summing function but it doesn't seem to work
There is also a condition on this sum: [TIPE GRAAN] not equal to 'WITMIELIES'
Can someone please help me with this
Sum Aggregation only works Numeric not for characteristics. So, You would need this if it is number
RangeSum([VERVOER-TARIEF], VERVOER)*([FAKTUUR MASSA]/1000)
Thank you!
It works, I appreciate your help
I assume that you need something like this:
sum(aggr(
sum({< [TIPE GRAAN] -={'WITMIELIES'}>} ([VERVOER-TARIEF] + VERVOER)*[FAKTUUR MASSA]/1000),
YourChartDimensions))
whereby the aggr is only needed if you want to display partial sums or totals.
- Marcus
THANK YOU!
You can flag "Correct answer" follows Qlik Community Tip: Marking Replies as Correct or Helpful