topic Re: Multidimensional Sum in QlikView

Multidimensional Sum

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I have a table .
I want to add an expression to obtain a third column with the sum as an example

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

Gysbert_Wassenaar — Wed, 18 May 2016 16:00:20 GMT

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

Thu, 19 May 2016 09:31:45 GMT

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