Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table where I only want to count grid mismatch that are showing great than 5 in the cabinet. This is how it look in the pivot table I want to create. I tried this but but didn't do what I was looking for Count({<Grid_Check={'Grid Mismatch'}>} cabinet)
Cabinet | Grid Mismatch |
087/15 | 11 |
087/10 | 7 |
087/15 | 3 |
120/05 | 3 |
120/07 | 2 |
127/58 | 5 |
121/45 | 6 |
020/48 | 10 |
020/30 | 0 |
059/12 | 0 |
210/20 | 0 |
015/20 | 3 |
Its bit confusing, do you want to count Cabinets where Grid Mismatch is >5, looks like you mentioned it just opposite in the problem statement.
If you are counting Cabinet where Grid Mismatch is >5 then it could be like this -
Count({<[Grid Mismatch] = {">5"}>}Cabinet)
What is Grid_Check in your expression you tried? This would be your expression:
count({<[Grid Mismatch] = {">5"} >} Cabinet)
The field in qlik is Grid_check in that I have Grid_Mismatch and Match. But I only want to see the grid mismatch greater than 5
@Aitelli_805 You need to share how the Grid_check looks like and how its linked to Grid_Mismatch and match, You didn't share full details in your sample data so we don't know what exactly you need
This how the table look. And want to create a pivot table only to look for grid mismatch greater than 5.
Status | Power ON | ROOM1 | TEST ROOM | SAP status | Computer Room Mismatch | Grid | RFIDgrid | Grid_Check |
Present | TRUE | DH1-3 | ODH1 | INST | Computer Room Mismatch | 118/72 | 113/082 | Grid Mismatch |
Present | TRUE | ODH2 | None | INST | Computer Room Mismatch | 044/012 | NONE | Grid Mismatch |
Present | TRUE | ODH1 | ODH2 | INST | Computer Room Mismatch | 062/087 | 044/032 | Grid Mismatch |
Present | TRUE | ODH1 | None | INST | Computer Room Mismatch | 044/069 | NONE | Grid Mismatch |
Present | TRUE | ODH1 | ODH2 | INST | Computer Room Mismatch | 071/095 | 059/042 | Grid Mismatch |
Present | TRUE | DH1-3 | None | INST | Computer Room Mismatch | 052/71 | NONE | Grid Mismatch |
Present | TRUE | DH1-3 | None | INST | Computer Room Mismatch | 121/10 | NONE | Grid Mismatch |
Present | TRUE | DH1-3 | None | INST | Computer Room Mismatch | 163/34 | NONE | Grid Mismatch |
Present | TRUE | DH1-3 | None | INST | Computer Room Mismatch | 055/05 | NONE | Grid Mismatch |
Present | TRUE | ODH1 | Interface Room | WHAR | Computer Room Mismatch | 035/094 | NONE | Grid Mismatch |
Present | TRUE | ODH1 | ODH2 | INST | Computer Room Mismatch | 062/077 | 080/039 | Grid Mismatch |
Present | TRUE | ODH1 | ODH2 | INST | Computer Room Mismatch | 062/069 | 050/038 | Grid Mismatch |
Present | TRUE | ODH1 | ODH2 | INST | Computer Room Mismatch | 062/069 | 041/039 | Grid Mismatch |
Present | TRUE | ODH2 | None | INST | Computer Room Mismatch | 005/014 | NONE | Grid Mismatch |
Present | TRUE | PDH10 | DH1-3 | INST | Computer Room Mismatch | BG/108 | 060/55 | Grid Mismatch |
Present | TRUE | DH1-3 | ODH1 | INST | Computer Room Mismatch | 118/72 | 113/082 | Grid Mismatch |
Present | TRUE | DH1-3 | ODH1 | INST | Computer Room Mismatch | 171/30 | 035/092 | Grid Mismatch |
Present | TRUE | ODH2 | ODH2 | INST | Match | 077/012 | 044/038 | Grid Mismatch |
Present | TRUE | DH1-3 | DH1-3 | INST | Match | 160/18 | NONE | Grid Mismatch |
Present | TRUE | DH1-3 | DH1-3 | INST | Match | 160/18 | NONE | Grid Mismatch |
Present | TRUE | ODH1 | ODH1 | INST | Match | 107/081 | NONE | Grid Mismatch |
Present | TRUE | ODH1 | ODH1 | INST | Match | 107/081 | NONE | Grid Mismatch |
Present | TRUE | ODH2 | ODH2 | INST | Match | 095/036 | NONE | Grid Mismatch |
Present | TRUE | ODH2 | ODH2 | INST | Match | 095/036 | NONE | Grid Mismatch |
Present | TRUE | ODH2 | ODH2 | INST | Match | 095/036 | NONE | Grid Mismatch |
Present | TRUE | ODH2 | ODH2 | INST | Match | 062/020 | NONE | Grid Mismatch |
Present | TRUE | ODH1 | ODH1 | INST | Match | 059/088 | NONE | Grid Mismatch |
Present | TRUE | ODH1 | ODH1 | INST | Match | 104/080 | NONE | Grid Mismatch |
Present | TRUE | ODH1 | ODH1 | INST | Match | 104/080 | NONE | Grid Mismatch |
Present | TRUE | ODH1 | ODH1 | INST | Match | 104/080 | NONE | Grid Mismatch |
Present | TRUE | ODH1 | ODH1 | INST | Match | 059/084 | NONE | Grid Mismatch |