Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI team,
I'm new to Qlik. Need help with expression. I want to remove the entire row if the Status collum is equal to 'H'.
My table is as per below.
Item_No | Status | Date | Segment | Amount |
00001 | H | 1/26/2022 | Office | 2900.00 |
00002 | D | 1/26/2022 | Office | 19841.00 |
00003 | F | 1/25/2022 | Office | 100.00 |
00004 | D | 1/20/2022 | Office | 9.90 |
00005 | D | 1/20/2022 | Office | 52.00 |
00006 | H | 1/20/2022 | Office | 3810.00 |
00007 | H | 1/19/2022 | Office | 518.00 |
00008 | H | 1/19/2022 | Office | 4.00 |
Hello,
In Data load editor if you have the following script:
LOAD
tem_No,
Status,
"Date",
Segment,
Amount
FROM [...]
(...);
The outcome is the entire table:
However adding the WHERE clause:
LOAD
tem_No,
Status,
"Date",
Segment,
Amount
FROM [...]
(...)
Where NOT Status = 'H';
Will give you:
As you can see, all the records where Status field equals with "H", are missing
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members.
Hello,
In Data load editor if you have the following script:
LOAD
tem_No,
Status,
"Date",
Segment,
Amount
FROM [...]
(...);
The outcome is the entire table:
However adding the WHERE clause:
LOAD
tem_No,
Status,
"Date",
Segment,
Amount
FROM [...]
(...)
Where NOT Status = 'H';
Will give you:
As you can see, all the records where Status field equals with "H", are missing
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members.
Hi Andrei_Cusnir,
Tks for the solution. its work. i was finding where is the option to edit the query. By the way, can recommend me any tutorial for beginners?
Hello,
I am glad that it is working as needed! As far as it concerns tutorial for beginners you can refer to the following links:
Additionally, you can obtain "Qlik Certifications & Qualifications" [4], where you can also find training offerings etc.
---
[1] https://help.qlik.com/en-US/sense/November2021/Content/Sense_Helpsites/Tutorials.htm
[2] https://www.youtube.com/c/QlikHelp-Videos/videos
[3] https://www.youtube.com/c/QlikSupport/videos
[4] https://www.qlik.com/us/services/training/certifications-and-qualifications