topic Re: Reduce Data / Keep possible values removes valid data in QlikView

Reduce Data / Keep possible values removes valid data

avantime — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

After reloading my app I reduce the data via macro.

The problem is that the data reduction affects valid data also, more exactly, data in hidden tables (which I trigger using buttons).

Any solution?

Re: Reduce Data / Keep possible values removes valid data

jonathandienst — Tue, 14 Feb 2017 13:18:55 GMT

Difficult to say without looking in some detail at your data model.

>> more exactly, data in hidden tables (which I trigger using buttons).

I am not sure what you mean by that.

Re: Reduce Data / Keep possible values removes valid data

avantime — Tue, 14 Feb 2017 13:21:32 GMT

By hidden table I mean tables (or charts) with conditional show rule.

I will try to build an app to show you what I mean.

Re: Reduce Data / Keep possible values removes valid data

jonathandienst — Tue, 14 Feb 2017 13:27:44 GMT

The data reduction happens to the data model based on the selections in force when you do the reduction. The status (shown/hidden eg) of front end objects plays no part in the data reduction. The data that is disappearing is being removed from the underlying data model.

It sounds like you are doing this as part of a routine load. There may be a better way to do this in the load script itself.

Re: Reduce Data / Keep possible values removes valid data

avantime — Tue, 14 Feb 2017 13:41:44 GMT

The data reduction happens to the data model based on the selections in force when you do the reduction.

Didn`t know this, I thought the reduction was done regardless of current selections. This makes sense with the problem I have. Back to the drawing board then. Thanks!

Re: Reduce Data / Keep possible values removes valid data

avantime — Tue, 14 Feb 2017 14:12:59 GMT

Solved it by adding a Where Exists clause . Thank you Jonathan for your input!