help with a pivot-table

[#1]

Hi everybody,

I need a (simple) information how to get the following result in an qlikview-pivot table.

This is my Qlikview-Pivot now, there is not calculation. I put fix a '1' in it.

But I want to have it like below. What do I have to do?

Thanks for you help in advance.

[robert_mika]

Is the Excel Column E & F based on calculations or those are hard writen value?

If that's values only you can create Table Box in Qlikview instead of PT

[#3]

Hi Robert,

no this are not hard-written values. I have for every ProjektNr. the Info CapexCatagory and CapexType.

But CapexCatagory should appear like in my first post. Please find below the same Table without Pivot.

[PradeepReddy]

It seems u are not looking for  Grouping the data base on dimension.

If this is the case use the Straight table instead of  Pivot Table.

[NickHoff]

Use a straight table instead of a pivot table then:

Create mapping load(s) for an indicator i.e.

MapLumpSumIND:

MAPPING LOAD * INLINE [

    Project, LumpSum

    41127, 'X'

    31236, 'X'

    31243, 'X'

];

Apply the MAP in your fact

APPLYMAP('MapLumpSum',ProjeckNr.,' ') AS LumpSumIND,