Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Which selection do you want to retain?
the one that is not possible to make?
or the previous one?
all selections even if no results are returned (5 selections in total)
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?
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
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
There are no expressions, its a table box
But you have selection-triggers which should sometime (conditionally) not select certain values, right?
- Marcus
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'
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