topic Re: Clearing Alternate State in QlikView

Clearing Alternate State

robert_mika — Fri, 06 Oct 2017 08:30:21 GMT

Why the native 'Clear' button or 'Clear All' created as button does not clear all states?

My example below:

States: Current and New,

Trigger on 'New' State Listobox to to choose from 'Current' list box.

The selection box below (in Current state) still have selection after the Clear button is pressed.

The 'Clear' icon within the box does not work either.

Just changing the selections from being divided by '|'

(From expression)

to ','

I found out as well that the 'Current Selection' box must have one field in it.

You can clear everything but one field need to stay inside the box.

Re: Clearing Alternate State

swuehl — Fri, 06 Oct 2017 08:32:28 GMT

Could you post a small sample QVW?

Re: Clearing Alternate State

robert_mika — Fri, 06 Oct 2017 09:42:25 GMT

Hi Stefan.

Thank you for replay.

I can not from current data not sure if I can replicate that example somehow diffrent

Any thoughts without saying the example?

My expression to pick up the entry from the Current state is:

(as a trigger on field ,'On select')

=replace(replace('(' & Concat(DISTINCT {Movement_New} Level_1, '|') & ')',' ','?'),'&','?')

Re: Clearing Alternate State

marcus_sommer — Fri, 06 Oct 2017 11:23:44 GMT

Maybe you could instead of a clear-action use a selection-action with: = null() to clear your field. Normally it worked reliable for this purpose whereby I never tried it by using states.

- Marcus