Forum Discussion
Solved
hi
i have a table like below:
| Category | Product | Amount |
A | a1 | 50 |
| A | a2 | 60 |
| A | a3 | 35 |
| B | b1 | 25 |
| B | b2 | 48 |
| C | c1 | 690 |
| D | d1 | 100 |
i need chart that only show catogory B
in qlikview i can use this for dim
any body can help me?
omid5ive , put Amount on card visual and use visual level filter on category
or create a measure and use
calculate(sum(Table[Amount]), filter(Table, Table[Category] ="B"))
1 Reply
omid5ive , put Amount on card visual and use visual level filter on category
or create a measure and use
calculate(sum(Table[Amount]), filter(Table, Table[Category] ="B"))