Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a sales funnel dashboard setup that shows funnel value based on all kinds of variables like sales stage, product, date.
I want to show a sales order YTD (in millions) value in the same sheet and I can get this using a simple KPI with this formula:
sum([Order Value])/1000000
My problem is that as soon as change a variable like status or product or date, the value goes to ZERO.
Surely I don't have to ignore all of the other field one-by-one?
Is there a way to tell the dashboard to keep the Sum([Order value]) constant, even if I change variables from the other data source?
Kind regards
Oliver
Check this link out:
QlikFit: Set analysis that ignores all selections except a few
Basically use "1" as modifier plus "P" to use the dimensions you need
sum({1<Dim1=P(Dim1)>}[Order Value])/1000000