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

Multidimensional Sum

Hi All

I have a table .
I want to add an expression to obtain a third column with the sum as an exampleBook1 - Excel_2.jpg

I write this formula:

Sum({<Quantity> }Month) but i need insert Fruit  as this formula  Sum({<Quantity> }Month,Fruit) but dont work in qlik.

Same Idea?

Thanks

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Use Sum(Quantity) as expression in a straight table with Fruit and Month as dimensions.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Use Sum(Quantity) as expression in a straight table with Fruit and Month as dimensions.


talk is cheap, supply exceeds demand
Not applicable
Author

Your answer is correct ,
the first did not work because I was using a dimension with a similar name to other tables .
careless mistake thanks