topic group by in QlikView

group by

Tue, 22 Jun 2010 19:24:59 GMT

Hi All

Here is my problem

When there are multiple markets within one application the market share calculations are not grouping by market. Instead they are using the total of all markets in the denominator of the % calculation. Any help will be appreciated.

group by

Tue, 22 Jun 2010 22:08:46 GMT

Could you show us your expression?

I'm guessing you are doing something like:

Sum(Sales)/Sum(TOTAL Sales)

If so, you want:

Sum(Sales)/Sum(TOTAL <Market> Sales)

group by

Tue, 22 Jun 2010 23:04:57 GMT

I don't have expression handy. But, as soon as I get to work tomorrow I'll share the expression.

group by

Fri, 25 Jun 2010 00:05:20 GMT

(sum(PRJTD_NRX_CNT)/sum(All PRJTD_NRX_CNT)) This is what I am doing. What I want it to do is respect the current selection of market in the denominator. I think ALL word is the problem here.

group by

Oleg_Troyansky — Fri, 25 Jun 2010 04:04:21 GMT

Yes, you are right in your assessment - keyword ALL ignores all the selections and always returns the summary for the whole document.

As an alternative, symbol TOTAL will ignore Chart Dimensions, but respect User Selections. In addition, if Market is one of your Chart Dimensions, you can use TOTAL <Market> to limit your summary only to the relevant Market.

cheers,