topic Exclude a field from Reduc in QlikView

Exclude a field from Reduc

Anonymous — Tue, 25 Feb 2014 13:17:25 GMT

found this in the community : "Reduce data is a great feature. However it also deletes any setting from list boxes marked with "Always One Selected Value". Therefore: Exclude a field from Reduce data to avoid this."

how could i do this ? been going crazy on this issue. need to do reduce but how can i keep the "Always One Selected Value" ?

Thanks a lot guys

Re: Exclude a field from Reduc

Tue, 25 Feb 2014 14:14:12 GMT

I do not think so this feature is available right now.

Re: Exclude a field from Reduc

Anonymous — Tue, 25 Feb 2014 15:04:35 GMT

how? can u send a screen shot?

Re: Re: Exclude a field from Reduc

SunilChauhan — Tue, 25 Feb 2014 15:10:58 GMT

take a list box and then go to properties and select on

"Always One value selected" in General tabl

Re: Re: Exclude a field from Reduc

Anonymous — Tue, 25 Feb 2014 15:56:45 GMT

yes i know, but after you select the "Always One value selected" in the list box and you run reduce the "Always One value selected" disappears

Re: Exclude a field from Reduc

Wed, 26 Feb 2014 05:28:07 GMT

Hello Jonathan,

The case trying to do is something which goes against the requirement of "Always one value selected" for Listbox.

Here is the case,

The pre-requiste for "Always one value selected" is that you need to first Select a single value and then this checkbox gets enabled.

Now,

If you Reduce Data with "Remove All Values" option, then it will make the ListBOx empty. and when you again reload the data, then in order to enable "Always one value selected" you have to select a single value. Does that make sense?

The other way I tried was, Reduce Data with "Keep Possible Values" this will not make the Listbox empty, thus a single value will be selected and so "Always one value selected" option will remain enabled.

Moreover, the requirement you saying, is already being added as an Idea to the community, So Qlik adminstrators might think of this in coming future.

Hope that was helpful.

THanks,

Angad

Re: Exclude a field from Reduc

Anonymous — Wed, 26 Feb 2014 05:40:46 GMT

Jonathan,

You can also reduce the data by performing a limited load. Go to Edit Script > Debug > then check the box next to limited load. Usually 100 or 1000 rows will suffice, but depending on your data you may need to increase this to guarantee values will populate the fields you have checked as always one selected (e.g. a where clause could potentially eliminate all values in a given table using a limited load)

This is the method I use to reduce data in documents while maintaining the "Always One Selected Value" function.

-Sean