Load on a filter

[Shrikant]

Hello,

I have a 2 tables Item and Stock. ItemID is the key, I want to load stock of all items but first by default the loaded data in chart should be item starting with X1 and Y1 . it should work like filters applied and then when we use clear it should display stock of all items in the chart.

Please help to achieve this.

Thanks

Shrikant

[abhijitnalekar]

Hi @Shrikant ,

Do you want to apply this condition only on a specific chart or on a whole sheet?

[Shrikant]

Hello Abhijit,

I have only 1 chart in this app and i want to load with filtered data Item X1 and Y1 and then user should be able to change the selection to all items or some different items

Thanks

Shrikant 

[abhijitnalekar · Accepted solution]

Hi @Shrikant ,

This can be achieved by using sheet level trigger.

In Sheet properties go to Action --> Add New Action --> Select values in field-->Seelct Field-->and Put Field value which you want to apply as a filter.

In your case values will be X1 and Y1.

Note : Need to create two separate actions if you have different fields.

Hope this resolve your issue.

[Shrikant]

Hello @abhijitnalekar,

Thanks for logic, just to confirm i am working this in QlikView and not QlikSense.

I tried yours steps in Document properties in OnPOstReload event and it works 50%. I want to filter on 2 conditions ItemID begins with X1 OR Y1

In this it works only if i put 1 value X1* or Y1*. I f I put both as below it shows all records 😔 I also tried adding 1 more action but then it works on only second action filter

any suggestion how can i filter on X1* or Y1*

Thanks

Shrikant

[Shrikant · Accepted solution]

It worked with (X1*|Y1*)... Thanks for idea 🤗

[abhijitnalekar]

Great!!! Happy that my suggestion worked to get to the solution.