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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ethel
Creator III
Creator III

filtering data before uploading

Hello, could you please help me to filter data in data loader.

I have fact table

VendorId

LocationId

Total.

I have table Location with dimensions

LocationID

Location

LocationType.

If Location type is A, I have to upload this data.

I cannot simply write where clause(where location='A'). I have to use this condition in my set analysis formulas, but I have more than 20 reports. Is there a way, I can add this condition in data loader. I think there should be something with peek, but I'm not sure...

Thanks a lot in advance!!

 

 

 

Labels (3)
1 Solution

Accepted Solutions
albertovarela
Partner - Specialist
Partner - Specialist

1 Reply
albertovarela
Partner - Specialist
Partner - Specialist

2022-02-03_16-41-45.png