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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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.