Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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 ?

0 Replies