Pivot table customization in Qliksense

[Anonymous]

Hi,

I have a pivot table in excel as below and each of the columns have different logics.

Since each of the columns have different formulas and different headings (along with sub-divisions). Is it possible to do the same in  Qliksense pivot table?

If yes, how to achieve it? If not, what's the other way round?

Thanks in advance

[ogster1974]

Do not try to bring your data in as a straight piviot table its not a great data model to use in itself,

Bring in each measure as its own field with related identifiers then you can use it in lots of charts including piviots.

Example data structure

Client, Billable Type, Measure, Value

A, Scheduled, Billible Hours, 20

B, Scheduled, Billible Hours, 50

C, Scheduled, Billible Hours, 40

Client, Billable Type, Measure, Value

A, Scheduled, Non-Billible Hours, 20

B, Scheduled, Non-Billible Hours, 50

C, Scheduled, Non-Billible Hours, 40

Etc

In this format you can generate the calculations you need within Qlik itself

Regards

Andy

[vinieme12]

Check my response here, the approach is similar

Re: Headings that span multiple columns in a pivot table