P&L Statement Structure in Qliksense

gayatri7 — Tue, 18 Jul 2023 14:05:48 GMT

Hello All,

I have a requirement to display a complete P&L structure in a Pivot table even though I don't have the amount in the transaction table.

So I started creating a structure in Excel as shown below and tried joining with the Transaction table.

As I wanted all the descriptions from this Excel joining based on PID.

I tried right join, outer join, and Qlik association but in every case I have only all the PIs from the transactional table not from my Excel.

My Excel PIs are always getting filtered based on my transactional data. And I am missing the complete structure.

At least with outer join, I should get all records from both tables. But that is not happening.

Anything I am missing here?

Thanks in Advance!

Gayatri

topic P&L Statement Structure in Qliksense in App Development