Multi KPI with if statement

P_S — Tue, 09 Jul 2019 08:44:23 GMT

I'm trying to use Multi KPI to show customers with sales, margin, and more. I use Multi KPI with other measures and it show only the customers I would like to see but when I put measure with if statement the Multi KPI show all customers in data. This is the if statement that I used.

If(VDR1 = 'QLIK *', If(Sum({<[invoice date] = {">=03/25/2019<=12/31/2019"}>}[Net Margin (Performance Sales/PM)])*100/Sum({<[invoice date] = {">=03/25/2019<=12/31/2019"}>}[Net Revenue (Performance)]) > 7.99, If([Cust Name] = 'A', If(Sum({<[invoice date] = {">=03/25/2019<=12/31/2019"}, VDR1 = {"QLIK*"}>}[Net Revenue (Performance)]) >= 4000000, Sum({<[invoice date] = {">=03/25/2019<=12/31/2019"}, VDR1 = {"QLIK*"}>}[Net Revenue (Performance)])/100, If(Sum({<[invoice date] = {">=03/25/2019<=12/31/2019"}, VDR1 = {"QLIK*"}>}[Net Revenue (Performance)]) >= 2000000, Sum({<[invoice date] = {">=03/25/2019<=12/31/2019"}, VDR1 = {"QLIK*"}>}[Net Revenue (Performance)])*0.5/100, 0 ) ) ), If(Match([Cust Name], 'B','C', 'D'), If(Sum({<[invoice date] = {">=03/25/2019<=12/31/2019"}, VDR1 = {"QLIK*"}>}[Net Revenue (Performance)]) >= 2000000, Sum({<[invoice date] = {">=03/25/2019<=12/31/2019"}, VDR1 = {"QLIK*"}>}[Net Revenue (Performance)])/100, If(Sum({<[invoice date] = {">=03/25/2019<=12/31/2019"}, VDR1 = {"QLIK*"}>}[Net Revenue (Performance)]) >= 800000, Sum({<[invoice date] = {">=03/25/2019<=12/31/2019"}, VDR1 = {"QLIK*"}>}[Net Revenue (Performance)])*0.5/100, 0 ) ) ) ), If(VDR1 = 'X*', If(Sum({<[invoice date] = {">=03/25/2019<=12/31/2019"}>}[Net Margin (Performance Sales/PM)])*100/Sum({<[invoice date] = {">=03/25/2019<=12/31/2019"}>}[Net Revenue (Performance)]) > 9.99, If(Match([Cust Name], 'E','F', 'G', 'H', 'I', 'J', 'K', 'L'), If(Sum({<[invoice date] = {">=03/25/2019<=12/31/2019"}, VDR1 = {"X*"}>}[Net Revenue (Performance)]) >= 5000000, Sum({<[invoice date] = {">=03/25/2019<=12/31/2019"}, VDR1 = {"X*"}>}[Net Revenue (Performance)])*2/100, If(Sum({<[invoice date] = {">=03/25/2019<=12/31/2019"}, VDR1 = {"X*"}>}[Net Revenue (Performance)]) >= 3000000, Sum({<[invoice date] = {">=03/25/2019<=12/31/2019"}, VDR1 = {"X*"}>}[Net Revenue (Performance)])*1.5/100, If(Sum({<[invoice date] = {">=03/25/2019<=12/31/2019"}, VDR1 = {"X*"}>}[Net Revenue (Performance)]) >= 1000000, Sum({<[invoice date] = {">=03/25/2019<=12/31/2019"}, VDR1 = {"X*"}>}[Net Revenue (Performance)])/100, 0 ) ) ) ) ) ) )

I use Cust Name as dimension in Multi KPI. Any suggestion would be appreciated.

Re: Multi KPI with if statement

P_S — Thu, 11 Jul 2019 04:18:25 GMT

Hello, I have tried many different ways but it's not work. Any help is appreciated

topic Re: Multi KPI with if statement in App Development

Multi KPI with if statement

Re: Multi KPI with if statement