topic Re: Re: Subtotal on expression in QlikView

Subtotal on expression

Mon, 24 Feb 2014 19:01:18 GMT

Hi everyone!

I have a question, I don't know if it's possible to enable subtotals on expressions. I'm asking this because on the graphic properties sheet "Presentation" the option "show subtotal" remains disabled when is selected a expression.

Follow attached my example, I need this because I have a big pivot table full of set analysis expressions and each line is a different value. Then at the end of the column I'd like to show a subtotal.

Thanks!

Re: Subtotal on expression

maxgro — Mon, 24 Feb 2014 19:02:39 GMT

Example?

Re: Subtotal on expression

Mon, 24 Feb 2014 19:03:32 GMT

Sorry, now the post has the attachment : )

Re: Re: Subtotal on expression

Anonymous — Mon, 24 Feb 2014 19:10:14 GMT

This (attached)?

Re: Re: Re: Subtotal on expression

Anonymous — Mon, 24 Feb 2014 19:15:47 GMT

Or better this

Re: Re: Re: Subtotal on expression

Wed, 26 Feb 2014 11:28:25 GMT

Hi Michael,

yes...and...no : )

I've opened your .qvw and I saw that you made 4 examples of subtotal but all examples you are using a dimension to totalize. I'd like to know if on my example you could totalize a expression that's used as a row:

Re: Re: Re: Subtotal on expression

Anonymous — Wed, 26 Feb 2014 13:34:36 GMT

Eduardo,

To sum expression you have to create additional expression which is the sum of the other expressions. But in this case it is a challenge to present it the way you want. And the unnecessary challenge at that.

I believe that the bottom left chart in my example is what you need. Yes, "Nome" is used here as dimensions, and it is for a reason. I don't see any advantage using it as a set of expressions which are all the same just with the different "Nome" condition. Maybe a reason is that you want only specific Names to be included. In this case, you can do it in this single expression:

sum({<Nome={'Marcelo','Zeh','Fernando'}>} QtdSapatos)

It gives you an additional advantage - you can keep the list of names in a variable, so can update it without changing the expression itself.

Regards,

Michael

PS: And, if it is necessary to show 0's, you can create 0 amounts for all Nome/Area combination.

Re: Subtotal on expression

Wed, 26 Feb 2014 13:40:23 GMT

please find attachment i think i have done it according requirement

thanks

Re: Subtotal on expression

jonathandienst — Wed, 26 Feb 2014 14:05:16 GMT

Eduardo

You are trying to incorporate data logic in your expressions. It is better to design a data model that reflects the structure of what you need to report. This problem becomes much simpler if you include a a group or flag field in your model that indicates the special case made up of those three names.

Then it becomes a matter including this field in the dimensions or in a set expression.

HTH

Jonathan