Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

nikhilgarg
Valued Contributor

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
MVP & Luminary
MVP & Luminary

Re: Data reduction using mnultiple fields

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
Valued Contributor

Re: Data reduction using mnultiple fields

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?