Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

subtotal sum for multiple dimensions

Dear community

I'm stuck with subtotals

I attached file for example

I want a daily cash position for all our bank accounts

Therefore I took the last statement nr per bank account and found the corresponding amount (through firstsortedvalue)

However, I don't succeed in subtotaling the amounts per currency or per company

I took statement nr and amount as expressions and company, curreny and bank account nr as dimension

Any idea how to solve ?

Tags (2)
Community Browser