topic Clear selections bug in QlikView

Clear selections bug

Tue, 31 Mar 2015 15:07:56 GMT

Interacting with a pivot is fine, however when i press "Clear" the pivot does not react to any selections. For example

Before:

Then i press either the "Clear Selections" button, or the toolbar "Clear" button and i get this after i make new selection;

Re: Clear selections bug

MK_QSL — Tue, 31 Mar 2015 15:14:06 GMT

Check General tab of your Year and Quarter Listbox..

may be Always One Value Selected is Ticked... (enabled)

Re: Clear selections bug

Tue, 31 Mar 2015 15:23:57 GMT

Thank you for your quick response, but unfortunately no. I checked every object to see if it was enabled. Not one.

Re: Clear selections bug

MK_QSL — Tue, 31 Mar 2015 15:26:38 GMT

is there any Document Trigger or Sheet Trigger set up?

Re: Clear selections bug

Anonymous — Tue, 31 Mar 2015 15:31:15 GMT

Maybe you have selected a field in the trigger

for example:

Re: Clear selections bug

rubenmarin — Tue, 31 Mar 2015 15:34:23 GMT

Hi Steven, check in the general tab of the chart the calculation condition, maybe is set to work when only one dimension is selected, not two; or is set to select two years but the text doesn't tells.

Re: Clear selections bug

Wed, 01 Apr 2015 12:55:54 GMT

Thanks Ruben.

You're right it has to be the Calculation Condition. The table on top has a condition of GetSelectedCount(_dimension) >= 0 however, when i select clear all it crashes and says "Out of object memory"

the table on the bottom has the condition of GetSelectedCount(_dimension) > 0 It was the original condition that is not working with any selections.

Re: Clear selections bug

rubenmarin — Wed, 01 Apr 2015 13:05:49 GMT

Hi steven please check that the Pick Dimension(s) list is using _dimension Field. if not, change calculation condition to the field used in that list.

The table on top is easy to fail when you deselect all, if it's calculation condition is GetSelectedCount(_dimension) >= 0, it will try to calculate with all the dimensions.

Re: Clear selections bug

Wed, 01 Apr 2015 13:17:55 GMT

Ruben you are the man! If you were here I'd kiss you. I can't believe i overlooked such a simple solution.

Thanks again.

Re: Clear selections bug

rubenmarin — Wed, 01 Apr 2015 13:26:14 GMT

Glad to help! That kind of thanks bringing a smile is what encourage me to keep participating in community.