Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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