topic Re: sum each row for all items by type in QlikView

sum each row for all items by type

JACKNIEKERK — Tue, 05 Jan 2021 19:12:32 GMT

in graphic I have now Expression:
sum(Pick(match(FakUnitType,'K','S'), FakKilos * FakPrijs, FakStuks * FakPrijs))

is total off all rows, thats ok, but need per row subtotals based PLU field (Price Lookup Unit) = itemnuber)

This total sum on line Orange Jus etc.

wich script /epression i need for that, please see sample screenshot

would like too see 1 line Orange jus , total 54.45

Anil_Babu_Samineni — Tue, 05 Jan 2021 19:30:53 GMT

You can change that object to pivot table and enable partial sum for PLU?

QFabian — Tue, 05 Jan 2021 20:33:56 GMT

Hi @JACKNIEKERK , try adding some code to your expression :

sum ( <TOTAL TotallizerField > rest of your expression)

JACKNIEKERK — Wed, 06 Jan 2021 18:22:16 GMT

hello, can't get it right in syntax, will see suggestions,(see screenshot) please advise with sample

wat syntax should be, thanks

JACKNIEKERK — Thu, 07 Jan 2021 19:41:19 GMT

i recreated as pivot table as advised , now ok, thanks