Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
I am very new (a day in!) to Qlik Sense. I am looking for a better solution to manage financial data etc. I have a model (which I've been using in Excel power pivot and power bi) for a tailored presentation of a Profit Statement.
I've done a bit of research and PL Smart Pivot seems to be the way to go, but there need to address the sub totals in the report
Sales - Mapped to through to fact table
COGS - Mapped through to fact table
Gross profit - showing blank when display data
Operating Expenses - Mapped through to fact table
Operating Profit - showing blank when display data
Interest - Mapped through to fact table
Profit Before tax - Final total
SO question is - How do I get the subtotals to work???
Thanks
Pete
PS; On first look Qlik Sense walks all over my journeys scoping out power pivot and power bi!