topic Re: Conditional Partial Sum in QlikView

Conditional Partial Sum

dinuwanbr — Fri, 29 Jan 2016 03:12:04 GMT

Hi all,

Is it possible to get the partial sum of dimensions in a pivot table on conditions?

For an example I have 3 dimensions and want to get the partial sums on conditional base according to the preference.

Thanks in advance.

Rgds,

Dinu1

Re: Conditional Partial Sum

settu_periasamy — Fri, 29 Jan 2016 03:44:29 GMT

May be you can create another 3 dummy dimensions (with blank label name) and put your Expression in Enable Conditional box. Then, Show partial sum for these 3 dummy dimensions only. But this will show extra columns in your chart. you can adjust your column width..

Instead of this, May be you can create two charts (Straight and Pivot) and show/hide based on your preference.

Edit

You can create your same 3 dimension (twice) and one with conditional based with show partial sum and another one is normal..

Re: Conditional Partial Sum

PradeepReddy — Fri, 29 Jan 2016 04:50:42 GMT

try the solution provided by by settu.periyasamy.. it will work..

Re: Conditional Partial Sum

dinuwanbr — Fri, 29 Jan 2016 04:58:37 GMT

Hi,

Thanx for your response. But in actual scenario i have more than 20 dimensions and its a ad-hoc table. So this won't be the solution that i'm looking to.

Thanx and Rgds,

Dinu1

Re: Conditional Partial Sum

Anonymous — Fri, 29 Jan 2016 05:17:18 GMT

(SUM(COLUMN NAME=('VAULE ')SALES)+SUM(COLUMN NAME=('VAULE ')SALES))-SUM(COLUMN NAME=('VAULE ')SALES)

Re: Conditional Partial Sum

settu_periasamy — Fri, 29 Jan 2016 05:31:55 GMT

Let us know, if you found any good solutions.

may be check the attachment..