Hi, Qlikview community
I hope you can help me. I have small problem that needs solution.
I got pretty simple data set in my qlikview example.
I have a business and I want to observe/monitor all my Job Number that have total charges equal to zero.
I made a chart in the QV Example which is exactly like the data set below.
I want the chart to show me the same information except I don't want see the information when Total Charges are larger than 0.
The information which are red.
Anybody have any idea how to do that?
| Shipping terms point | Job Number | Commodity name | Quantity | Customer | Total Charges |
| NLRTM | RTM163 | CONSOLIDATE CARGO | 3 | Coca Cola | 0 |
| DKAAR | RTM162 | CONSOLIDATED CARGO JONAR | 3 | Pepsi Co | 0 |
| DKAAR | SIS241 | EMPTY CONTAINERS | 5 | Pepsi Co | 0 |
| DKAAR | SIS242 | EMPTY CONTAINERS | 15 | Pepsi Co | 0 |
| DKAAR | SIS243 | EMPTY CONTAINERS | 20 | Coca Cola | 0 |
| GBIMM | SIS241 | EMPTY CONTAINERS | 1 | Coca Cola | 0 |
| NLRTM | RTM164 | CONSOLIDATED CARGO JONAR | 1 | Pepsi Co | 193.324 |
| ISREY | RTM165 | CONSOLIDATE CARGO | 1 | Coca Cola | 195.240 |
regards Darri
