Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Clear selections bug

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;

Tags (2)
1 Solution

Accepted Solutions

Re: Clear selections bug

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.

View solution in original post

9 Replies
MVP
MVP

Re: Clear selections bug

Check General tab of your Year and Quarter Listbox..

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

Not applicable

Re: Clear selections bug

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

MVP
MVP

Re: Clear selections bug

is there any Document Trigger or Sheet Trigger set up?

maverjannet
Valued Contributor

Re: Clear selections bug

Maybe  you  have   selected  a field  in the  trigger

for  example:

1.1.PNG

Re: Clear selections bug

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.

Not applicable

Re: Clear selections bug

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.qlik com 1.PNG

Re: Clear selections bug

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.

View solution in original post

Not applicable

Re: Clear selections bug

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

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