topic Re: Ignoring Section access script in QlikView

Ignoring Section access script

Anonymous — Tue, 01 Sep 2015 06:21:13 GMT

Hi All,

We have a requirement where the user should be able to se the reduced data, but there should not be drop in the Total Volume, which is based on other data as well.

Suppose, we have a KPI saying total volume as sum(vol), then when we are reducing the application for one user, there is a reduction in sum(vol) as well.

Is there is any way, we can show the total volume to user.

Please assist.

Thanks & Regards,

Re: Ignoring Section access script

jonathandienst — Tue, 01 Sep 2015 06:35:12 GMT

The simplest way is to create a total volume field pre-aggregated at an appropriate aggregation level* and linked to a generic value of the field used for reduction. The SA table should automatically include a the generic value for all users.

*The "appropriate level" could be at the same level of granularity in the source data, except aggregated across the values of the field used for reduction.

You may have to explain to the users why the total is not same as the total sum of rows int their tables, and/or you could calculate an 'Others' value by subtracting all the known (reduced) amounts from the generic total.

Re: Ignoring Section access script

qlikviewwizard — Tue, 01 Sep 2015 07:13:00 GMT

As jonathan said, it is best to create new column at the script level itself.