Grid greater than 5

[Aitelli_805]

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

[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]

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

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

[Aitelli_805]

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]

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