topic Show only specific rows from a binary load in App Development

Show only specific rows from a binary load

qliknubi — Fri, 01 Jul 2022 10:47:00 GMT

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?

Re: Show only specific rows from a binary load

marcus_sommer — Fri, 01 Jul 2022 15:09:42 GMT

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

Re: Show only specific rows from a binary load

vinieme12 — Sat, 02 Jul 2022 05:10:50 GMT

You have 2 very easy Options

1) Inner Join(TableName)

2) Inner Keep(TableName)