Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Aitelli_805
Contributor II
Contributor II

Grid greater than 5

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
5 Replies
Digvijay_Singh

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)

stevejoyce
Specialist II
Specialist II

What is Grid_Check in your expression you tried?  This would be your expression:

count({<[Grid Mismatch] = {">5"} >} Cabinet)

Aitelli_805
Contributor II
Contributor II
Author

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 

Digvijay_Singh

@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

Aitelli_805
Contributor II
Contributor II
Author

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