Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Row Deletion

Hello Everyone,

Say I have a data set that looks like this:

Screenshot (10).png

Would it be possible to delete the data from row 6 once the data has been uploaded into Qlik?

All the best,

Alison 

1 Solution

Accepted Solutions
aarkay29
Specialist
Specialist

PFA

Load *

Where [Student ID]<>'29w';

Load * inline [

Student ID, Sex, Enrollment Start, Course

12a,F,12/06/2017,History

63d,M,12/06/2017,Art

15f,M,20/06/2017,Philosophy

16h,G,13/06/2017,History

29w,Q,12/06/2017,Economics

];


when you are loading from any database


Load *

From Database

Where

    [Student ID]<>'29w';

View solution in original post

15 Replies
eliran
Creator III
Creator III

Hi Alison,

You will need to reload the data, either by partial reload, or full reload.

What is the scenario you're trying to go for?

Eliran.

kaushiknsolanki

Hi,

Do you mean to say that when you load the data in qlik, you are getting null values for rows like 7,8 and 9?

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Not applicable
Author

Hi Eliran,

Thank you for your response.

How would you do that?

A colleague of mine uploaded a table to Qlik which included a totals row. So ideally he'd like to be able to delete that from the data post-upload. I just made this example data set for ease.

Not applicable
Author

Hi,

That's not a problem, I would just like to be able to remove the data found in row 6.

kaushiknsolanki

Hi,

There are couple of ways you can do that.

1. Use the basic transformation steps available when you load the data and use the delete option to delete the record manually.

2. If you have the Total Keyword in that raw, you can use the where clause to not take rows where the keyword is Total.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
eliran
Creator III
Creator III

Hi Alison,

It's something that needs to be taken care of in the ETL stage, you can't remove it when you're "viewing" the model.

Your only way to do it "on the fly" is filtering it manually.

So, if the field name is StudentID, just choose the total row value (29w) and then right click the field and click 'select excluded'.

You don't really have an ability to delete the data when viewing the app.

Hope it helps,

Eliran.

Not applicable
Author

Hi Kaunshik,

Thank you for your response.

Please can you provide a more expansive description, I don't really understand.

aarkay29
Specialist
Specialist

Hi

You can do something like this in the script if you don't want to load the lines

Load

*

From Table

Where [Student ID]<>'29w';

similarly you can apply this for your scenario.

Not applicable
Author

Hi Aar,

Thank you for your suggestion. But, I haven't been able to make it work.