P&L Pivot - June 2019

HugoBoyle — Tue, 17 Sep 2019 11:08:56 GMT

I have recently upgrade to Qliksense June 2019.

I want to use the P&L pivot to develop a P&L app.

I have loaded a table into the App that holds all the fields that I want to use in my calculations.

What I want to develop is a P&L that will show the following...

P&L

Heading Current Value

Gross Sales Value Sum(T_GSV) (Where T_GSV is a field from my table)

Invoiced Sales Sum(T_INV_SALES)

etc.

Not sure how to load the data or configure the P&L Pivot to get the above result.

Any help would be greatly appreciated.

Re: P&L Pivot - June 2019

Ilya_Bobrov — Tue, 10 Dec 2019 09:17:16 GMT

Hi! You need precalculate totals in this visualization in datamodel, then уach value will be unique.