Clear filers on straight table while keeping the selections on list box

[Yuhka]

Hello guys, I'm new to Qlikview.

I have a qvw which has 3 sheets: 1.Search Condition sheet, 2.Output Items sheet and 3. Result sheet.
As you can see on the Test_QVW, I 'd like to set conditions on 1st sheet, select output items on 2nd sheet and finally see the result on 3rd sheet.

Also on 3rd sheet result chart, you can filter item.

Now I would like to clear the filtering only on the result sheet chart without changing the conditions set on 1st sheet and output items selected on 2nd sheet.

Is it possible to clear the filtering on 3rd sheet result chart while keeping the selections on the other sheets?

Thank you for your support.

[miskinmaz]

You have to give try for below things:

setting triggers on 3 sheet.

probably  creating a inline table or set analysis to nullify the selection done on first two sheet

[gf · Accepted solution]

Have a look at this thread:

https://community.qlik.com/t5/QlikView-App-Development/Clear-fields-on-current-active-sheet/td-p/102...

[Wilson_Webb]

Have you tried to lock the selection?
it is rather manual but it does the job. You can then use alternate states for the behaviour on the other sheets.

[Yuhka]

Hello @gf,

Thank you for your information.

I've confirmed the thread you informed, and I found the solution.

For my qvw, I tried the alternate state.

I gave state "Search" for 1st and 2nd sheet. For 3rd sheet objects, I gave state "Result Selection".

Then I set the Action "Copy State Contens" on 2nd sheet Search button as copying state from "Search" to "Result Selection". Also set  the Action "Copy State Contens" on 3rd sheet Clear button as same as 2nd sheet Search button.

Finally when I click the 3rd sheet Clear button, the selection on 3rd sheet result chart is deleted and overwrote as state of "Search".

It worked perfectly!

Thank you very much for your help!