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!
