Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Show Company Avg in Section Access

Hello,

Currently I have limit each sales rep to their data only but I'd like to show a graph line of company avg versus theirs.  I'm guessing it needs to be scripted in the load somehow.  Please advise.

Thanks,

Vibol

1 Reply
MVP
MVP

Re: Show Company Avg in Section Access

Yes just create a table with a KEY and the average, may be like:

Avg:

Load

    Autonumber(Field1&Field2&Field3) as KEY,

    Avg(Sales) as CompanyAvgSales

resident <> Group by Field1, Field2, Field3;

Assuming Field4 (which is not there in the composite key) is your sale rep field.

Now create a similar key in your transnational table, it should work.

Community Browser