Retain selections even if there are no results

[matthewp]

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

[matthewp]

but i dont want it to select another field, i want it to select what i am telling it even if nothing will be returned

[Colin-Albert · Accepted solution]

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.

[swuehl]

matthewp wrote:

but i dont want it to select another field, i want it to select what i am telling it even if nothing will be returned

And that would render an incompatible selection state and causes your issues.

Or may I misunderstood what you are requesting? Could you post a small sample and your requested result?

[matthewp]

Thanks Colin,

That clears that up, yet another pitfall of qlikview

[Colin-Albert]

Put your selections into separate listboxes and you will see what is happening.

It's all about Green, White & Grey.

These blogs may help

The Power of Gray | Qlikview Cookbook

Green Is the Colour

[Colin-Albert]

Not a pitfall of QlikView, rather a pitfall of triggers.

Use list boxes and let your users discover for themselves the association between the data based on Green / White / Grey.

[matthewp]

End users want instant results they dont have to select them selves

[swuehl]

Then maybe let them use a (static) reporting tool, and not an interactive business discovery tool