topic help with a pivot-table in QlikView

help with a pivot-table

Thu, 19 Feb 2015 13:30:14 GMT

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 — Thu, 19 Feb 2015 13:52:04 GMT

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

Thu, 19 Feb 2015 14:00:39 GMT

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 — Thu, 19 Feb 2015 14:01:01 GMT

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 — Thu, 19 Feb 2015 14:09:51 GMT

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,