Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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 

Tags (2)
1 Solution

Accepted Solutions
aarkay29
Valued Contributor

Re: Row Deletion

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';

15 Replies
eliran_s
Contributor II

Re: Row Deletion

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.

Re: Row Deletion

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

Not applicable

Re: Row Deletion

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

Re: Row Deletion

Hi,

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

Re: Row Deletion

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

eliran_s
Contributor II

Re: Row Deletion

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

Re: Row Deletion

Hi Kaunshik,

Thank you for your response.

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

aarkay29
Valued Contributor

Re: Row Deletion

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

Re: Row Deletion

Hi Aar,

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

Community Browser