Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi! You need precalculate totals in this visualization in datamodel, then уach value will be unique.