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: 
nikhilgarg
Specialist II
Specialist II

Data reduction using mnultiple fields

HEy,

I was going thru the following article:

Data Reduction Using Multiple Fields

But couldn't understand how we decide where we put authorization key? How OrdersDetails table is selected for Authorization key.

Can somebody help me here.

Thanks

2 Replies
Gysbert_Wassenaar

Beacuse OrderDetails is the only table where that key makes sense. There can be multiple products per order so multiple productgroups per order are possible. Therefore the key cannot be part of the Orders table. Country is not related to Product so the key can't be part of the Products table. The only place where that key can be created is in the OrderDetails table.


talk is cheap, supply exceeds demand
nikhilgarg
Specialist II
Specialist II
Author

Hey,

I have a qstn. In my application section access working fine as per reduction field but when i reload then all data is being shown. Why is it so?