Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qliknubi
Contributor II
Contributor II

Show only specific rows from a binary load

Hi Experts,

I tried searching for sample scripts but found none. Is there a way to show only the selected/specific rows that contain some values. So basically, I have an app which has over 20 million rows and another app that does the binary load. I don't want to show the entire rows on my sheet because data is huge, I only have to look for 2-10 IDs from that 20 million rows. How do I achieve this?

Labels (1)
2 Replies
marcus_sommer

A binary load fetched always the entire data-model with all data and couldn't be customized in any way. But you could remove the unwanted data afterwards, for example with a noconcatenate resident-load of your fact-table with an appropriate where-clause and then deleting the origin table or maybe filtering the data with an inner join load.

An alternatively might be to apply a section access which could remove the unwanted records during the opening of the application.

Both methods will have their costs - so you may also considering not to apply a binary load else loading the wanted data from qvd's.

- Marcus

vinieme12
Champion III
Champion III

You have 2 very easy Options

1) Inner Join(TableName)

2) Inner Keep(TableName)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.