Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Retain selections even if there are no results

I have a sheet that has several triggers for default selections

however when there is no result sin my table box foe these selections is doesn't select them in the list boxes.

i want the list boxes to retain selections even if there are no results

1 Solution

Accepted Solutions
Highlighted

What you are describing is standard functionality in QlikView.

If your set of selections will result in no data being returned, then QlikView will clear all other selection that are preventing no data being returned.

You can see this on the desktop by trying to make selections that exclude each other.

QlikView does not permit users to make incompatible selection which result in no data being returned.

View solution in original post

17 Replies
Highlighted
MVP
MVP

Which selection do you want to retain?

the one that is not possible to make?

or the previous one?

Highlighted
Creator III
Creator III

all selections even if no results are returned (5 selections in total)

Highlighted
MVP
MVP

I assume your trigger is trying to create a selection state with incompatible selections, like

selecting a Customer and a Product which is actually excluded by the Customer selection.

Does this roughly describe your trigger settings and possible root cause?

Highlighted
Creator III
Creator III

Yeh i think so,

the selections work fine when there are results but if all 5 selections mean there is no results it disregards a selection

Highlighted
MVP & Luminary
MVP & Luminary

Maybe you could include a check if there are dimension-values available for those fields and if not you applied the action to a not existing field which meant that then nothing happens:

- Marcus

Highlighted
Creator III
Creator III

There are no expressions, its a table box

Highlighted
MVP & Luminary
MVP & Luminary

But you have selection-triggers which should sometime (conditionally) not select certain values, right?

- Marcus

Highlighted
Creator III
Creator III

Triggers are as follows

OnActivateSheet

     Select In Field

          Field: [Status]

          Search String: (Complete|In_Progress)

     Select In Field

          Field: [Check]

          Search String: ='Miss'

     Select In Field

          Field: [Type]

          Search String: (AB|XY)

     Select In Field

          Field: [ECheck]

          Search String: ='Inc'

     Select In Field

          Field: [BCheck]

          Search String: ='Other'

Highlighted
MVP & Luminary
MVP & Luminary

And my suggestion meant to set a condition to the field within a trigger:

OnActivateSheet

     Select In Field

          Field: if(Condition = true(), [Status], [AnotherNotExistingField])

          Search String: (Complete|In_Progress)

....

- Marcus