Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
HugoBoyle
Contributor II
Contributor II

P&L Pivot - June 2019

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.

1 Reply
Ilya_Bobrov
Contributor III
Contributor III

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