topic Re: Total expression in QlikView

Total expression

Thu, 10 Aug 2017 19:28:41 GMT

Hello everyone, how are you?

I want to know, if is possible make an expresison where each row takes its subtotal value.

Example below:

Kind regards, Luiz

kaushiknsolanki — Thu, 10 Aug 2017 19:33:29 GMT

Try this.

Sum(Total <Item> Sales)

Regards,

Kaushik Solanki

sunny_talwar — Thu, 10 Aug 2017 19:36:47 GMT

You mean

Sum(TOTAL <Category> Sales)

kaushiknsolanki — Thu, 10 Aug 2017 19:43:38 GMT

Thanks Sunny.

I always get confused here. But this time I got it.

Will try to be correct next time

Regards,

Kaushik Solanki

Thu, 10 Aug 2017 19:46:19 GMT

There is a complication, it has to be a set analysis, I mean, the original sum is a set analysis with some conditions, example:

(Sum( Distinct {$< Category-={} >} Sales)/1000)

sunny_talwar — Thu, 10 Aug 2017 19:47:45 GMT

This should work

(Sum(TOTAL <Category> Distinct {$< Category-={} >} Sales)/1000)

sunny_talwar — Thu, 10 Aug 2017 19:55:46 GMT

I used to get confused in the past, actually I still do....