Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Ignoring Section access script

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,

MK

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
qlikviewwizard
Master II
Master II

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