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?