Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
praneethpasari
New Contributor

How to delete a specific row of the data in the data manager editor

Dear all, 

 

I uploaded the data from the excel and few rows with zero values/Null rows are all created.  How I can delete this null rows in my data manager editor? 

Thanks in advance 

Regards 

Praneeth Pasari 

Labels (3)
11 Replies
Partner
Partner

Re: How to delete a specific row of the data in the data manager editor

Hi Praneet,

Is this at the end of you document of between the data? Because if it's at the end, it's not a real problem. Do you also see this in the Data Model Viewer?

Jordy

Climber

Work smarter, not harder
Highlighted
praneethpasari
New Contributor

Re: How to delete a specific row of the data in the data manager editor

Yes, I can. 

But I would also like to know, how to delete a specific row data in the data manager as we do in python or excel. 

Partner
Partner

Re: How to delete a specific row of the data in the data manager editor

There is no possibility to actually 'delete' a row in Qlik. What you can do is go to the Data Load Editor, unlock your script and add the statement:

Where not isnull([YourField])

or

Where [YourField] <> ''

YourField should be your table key field, the unique field in your table.

Jordy

Climber 

Work smarter, not harder
praneethpasari
New Contributor

Re: How to delete a specific row of the data in the data manager editor

I don't have any unique field in my data as the data is the project reporting data for every month. I had consolidated all the projects data in to one Database so most of the data is repetitive untill or unless I use two column together. I wont be able to have unique field. 

Can I just say isnull to my complete database to remove all empty rows ?, if so how I can do it ?  

praneethpasari
New Contributor

Re: How to delete a specific row of the data in the data manager editor

If you see the screenshot the summary of the column shows me that there are 12% of values are null, how I can remove them ? 

Partner
Partner

Re: How to delete a specific row of the data in the data manager editor

No problem, you can do this on Reporting Month:

Where not isnull([Reporting Month])

This will leave you without any empty rows.

Jordy

Climber 

Work smarter, not harder
praneethpasari
New Contributor

Re: How to delete a specific row of the data in the data manager editor

I tried but I am getting below error. 

Partner
Partner

Re: How to delete a specific row of the data in the data manager editor

I see that you are using this within your auto generated calendar, is that correct?

You need to do this at the end of you fact table! The reason why you see this error is because you misplaced the  ;  because your where needs to be before the   ;   . You get that?

Jordy

Climber

Work smarter, not harder
praneethpasari
New Contributor

Re: How to delete a specific row of the data in the data manager editor

Could you please elobrate a bit more. 

In my autogenerate section I have only two sub section 

1. Data loaded 

2 Auto calender 

Do I need to create a new section (using add symbol on the left ) and run the script ?