topic Re: link table data redunction in QlikView

link table data redunction

ilanbaruch — Thu, 09 Feb 2017 15:43:35 GMT

hi all,

i have transaction table, budget table and calendar connected through link table

all is working fine, except when saving to access point folder values from budget table being reduced.

unchecked 'reduce data' from security tab on document properties.

any idaes?

advanced thanks

Re: link table data redunction

marcus_sommer — Thu, 09 Feb 2017 18:24:30 GMT

This could happens if section access is implemented - therefore check for it.

- Marcus

Re: link table data redunction

ilanbaruch — Thu, 09 Feb 2017 19:32:25 GMT

thank you Marcus, you are correct

is there any way to bypass this?

advanced thanks

Re: link table data redunction

marcus_sommer — Fri, 10 Feb 2017 08:03:59 GMT

This meant that some key-values (from the section access to the datamodel) aren't (correctly) mentioned within the section access or that they are NULL then NULL entries won't be covered by a * wildcard. Therefore there is no way to bypass it unless to check and clean these key-values and maybe replace and/or fullfill the missing one with 'Null' or 'Missing' or anything what you like and then assigning them within the section access, too.

- Marcus

Re: link table data redunction

ilanbaruch — Mon, 13 Feb 2017 17:04:44 GMT

thank you Marcus

Marcus Sommer <span class="icon-status-icon icon-mvp" title="Mvp"></span> wrote:

This meant that some key-values (from the section access to the datamodel) aren't (correctly) mentioned within the section access or that they are NULL then NULL entries won't be covered by a * wildcard. Therefore there is no way to bypass it unless to check and clean these key-values and maybe replace and/or fullfill the missing one with 'Null' or 'Missing' or anything what you like and then assigning them within the section access, too.

- Marcus