Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
HugoBoyle
Contributor II
Contributor II
‎2019-09-17 07:08 AM

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.

843 Views
0 Likes
1 Reply
Ilya_Bobrov
Contributor III
Contributor III
‎2019-12-10 04:16 AM

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

781 Views
0 Likes