Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
ilanbaruch
Contributor III

link table data redunction

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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: link table data redunction

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

4 Replies
MVP & Luminary
MVP & Luminary

Re: link table data redunction

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

- Marcus

ilanbaruch
Contributor III

Re: link table data redunction

thank you Marcus, you are correct

is there any way to bypass this?

advanced thanks

MVP & Luminary
MVP & Luminary

Re: link table data redunction

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

ilanbaruch
Contributor III

Re: link table data redunction

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