topic Re: adding an extra calculated dimension in QlikView

adding an extra calculated dimension

Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have a problem with a table like this.

I try to create a pivot table like this ;

I can do it with excel by creating calculated item in PivotTable. Is there anyway for this in Qlikview PivotTable

Gysbert_Wassenaar — Tue, 19 Jul 2016 09:47:49 GMT

Use Month as Person as dimensions in the pivot table. And enable the Indent Mode and Use Only First Dimension Label options on the Style tab.

Tue, 19 Jul 2016 10:26:41 GMT

Thanks for quick reply, but my problem is different.

As you see ; I add extra calculated dimensions Month Names.

January ; has only January's values.

February ; has both (January & February) values.

March ; (Sum of March & earlier month records)

Gysbert_Wassenaar — Tue, 19 Jul 2016 10:51:23 GMT

You need to create an extra table for that:

NewMonths:

LOAD * INLINE [

NewMonth, Month

1,1

2,2

January, 1

Februari, 1

Februari, 2

];

Then use NewMonth as dimension instead of Month.