Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Why match function show the total result too

so i have a data , example

 

Company          Total profit

A                            2000

B                           5000

C                            3000

 

when i use the edit expression , i want to show the total profit of company A and C

so i use =Match(company,'A','C')

but when i generate the piechart , it will show the profit from company A, C and (the total of totalprofit from A,B,C - total profit from A,C)

how to remove the result of(total profit from A,B,C-total profit from A,C)? because i dont even declare it in the expression

Labels (1)
1 Reply
Highlighted
MVP
MVP

Are you using calculated dimension? Try instead measure expression, like:

Sum(If(Match(Company,'A','C'), [Total profit]))