Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

Qliksense - displaying a Pnl in a straight table

Hello Qlikers!

Need a quick help!

I am working on displaying a Profit and loss statement. This PnL has around 20 indicators.

So i have created an excel sheet with the title of the 20 indicators, along side I have put the corresponding formulae to be able to display a table in the profit and loss account format.

After loading this table in Qlik which is not linked to the model, the numbers don't show up. I have to select a given row for the calculation to show up...

I have tried smart pivot extension, but number of KPIs are limited.

Any ideas, suggestions?