topic Re: How do I do add both the rows and the columns? in QlikView

How do I do add both the rows and the columns?

josephinetedesc — Wed, 13 Sep 2017 04:46:27 GMT

Hi all

This is a continuation of the question that I asked here - but it might have nothing to do with it.

I want to do something like this:

I can get the sum of the columns but I cannot get the sum of the rows.

Also where should I look for something that will show me how to do an expansion of a table - but one step at a time. For for example

All Months - then

all div_name_short then

Drums, flue, Guitar

Thank you

Anil_Babu_Samineni — Wed, 13 Sep 2017 05:33:06 GMT

Try this way?

josephinetedesc — Wed, 13 Sep 2017 09:46:06 GMT

Thank you - I have now learnt about dimenionality!

I wonder if you could use it as a selection - i you choose dimensionality 1 the the total would show dimension 1 etc. ... I will experiment tomorrow

Thank you