topic Re: Pivot Table - Sum specific lines in QlikView

Pivot Table - Sum specific lines

vinicius_siquei — Sat, 26 Apr 2014 00:29:38 GMT

Folks,

I have the Pivot table below in my application.

As you can see, the line 5 and some others are not being displayed.

It happens, because line 5 is the sum of records from line 3 and 4.

Could anyone help me ?

I did this expression using Set Analysis, however the result was not displayed separated by month as it should be.

I also attached my application, in case anyone prefer.

Thanks,

Vinicius

Re: Pivot Table - Sum specific lines

whiteline — Sat, 26 Apr 2014 09:14:15 GMT

Hi.

Consider to change the data structure for such requirements.

For example, you can create another field [Report Linha] and connect it with Linha field like this:

[Report Linha], Linha

01, 01

02, 02

03, 03

04, 04

05, 03

05, 04

...

Then you can use Report Linha as dimension and build the report using just Sum() expression.

Anyway, it's hard to do it with set analysis within the current data model as there is no relation between [Linha]=05 and any [Mes] value. You can see it if you create table box with these two fields.

Re: Pivot Table - Sum specific lines

preminqlik — Sat, 26 Apr 2014 12:06:59 GMT

Hi there,

find attachment

Re: Pivot Table - Sum specific lines

vinicius_siquei — Fri, 23 May 2014 14:44:28 GMT

Thanks for your answer. Very insightful.

Re: Pivot Table - Sum specific lines

vinicius_siquei — Fri, 23 May 2014 14:44:47 GMT

Thanks Kumar!