Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Apply data reduction only in certain table or field and not to whole data model?

Is there a way to apply data reduction only to certain fields/tables using section-access?

The following example explains my scenario:

Table Salesman                                                       Table Product

Saleman_name  Product                                          Product     Main_sales_region

A                         P1                                                   P1            R1

A                         P2                                                   P2            R2

B                         P3                                                   P3            R3

I have 2 sheets in my qvw file: Product Details and Region analysis. Product detail should show data only about those products that fall under the logged in salesman.

Whereas Region analysis sheet should take into consideration all the regions available and provide a comprehensive report on region-wise trend.

Now if I apply REDUCE to field Product and take USERNAME AS Salesman_name, the reduction is being applied to whole data model.

Therefore, if A logs in the page Product Details shows data only about P1 and P2 (which is perfectly fine) but at the same time, the Region Analysis page shows data only about R1 and R2(which is against my requirement).

Is there a way to mention explicitly within section access script that consider linked Products only but for Region consider all region?

1 Solution

Accepted Solutions
RedSky001
Contributor III

Re: Apply data reduction only in certain table or field and not to whole data model?

I wouldn't use section access for this. 

I would use set analysis within the expresisons of the Product Details sheet to only show the applicable data.

View solution in original post

1 Reply
RedSky001
Contributor III

Re: Apply data reduction only in certain table or field and not to whole data model?

I wouldn't use section access for this. 

I would use set analysis within the expresisons of the Product Details sheet to only show the applicable data.

View solution in original post