0 Replies Latest reply: Aug 22, 2017 6:52 AM by abhinav a RSS

    Qliksense - displaying a Pnl in a straight table

    abhinav a

      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?

       

      Regards!