Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
bobbydave
Creator III
Creator III

Removing row from excel on load

hi guys,

Maybe a tricky question. Not sure if it can be done.

I have an excel stats document that I am loading. However, on the document, it has a field when the report is generated that shows the created date in one of the rows. As you can imagine, when the stats document is loaded into excel, it has the row of data as is and a created: theDateAndTime.

I don't want to bring in the created date. I also had a TOTAL (COUNT) in the row which I removed by using an if statement to say,

if (row <> 'TOTAL (COUNT), show the rest of the data.

But with Created: theDateAndTime , the Date and Time are dynamic depending on when I pulled the report.

Anyone encountered this?

Help appreciated.

If all comes to all, I can have the person remove TOTAL (COUNT) and Created Date before the files are even loaded in Qlikview.

1 Solution

Accepted Solutions
bobbydave
Creator III
Creator III
Author

Not to worry, I used the wildcard match function and have it now fixed.

if(WildMatch(myGroup, 'whatIamLookingFor'), myGroup)

This only showed what I wanted it to show and also removed the Created Date and Total(count)

View solution in original post

1 Reply
bobbydave
Creator III
Creator III
Author

Not to worry, I used the wildcard match function and have it now fixed.

if(WildMatch(myGroup, 'whatIamLookingFor'), myGroup)

This only showed what I wanted it to show and also removed the Created Date and Total(count)