Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
Creator II
Creator II

Reducing data after loading seperate data tables

Hi,

In my QVW I load separate tables from different sources to build the star schema and keys.

Once I have the data in a star schema format I want to reduce the data by business line, so that when I build my dashboard, items the dimension tables that are not related to the business line are removed.

I also would like to know if I can exclude the grey items from the list boxes, I only need 100% associations.

Thanks

Tinkerz

 

 

 

 

 

2 Replies
mohamed_ahid
Partner - Specialist
Partner - Specialist

Hello,

try File -> Reduce Data ->Keep possible values

 

Regards

Brett_Bleess
Former Employee
Former Employee

Tinkerz, the only other idea I have would be to binary load the original file and then use resident load to only pull what you want and drop the other values that way, that would be more automated versus the other post, not sure what your requirements are here.  

Cheers,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.