topic Re: Load on a filter in QlikView

Load on a filter

Shrikant — Mon, 04 Oct 2021 11:04:09 GMT

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

Re: Load on a filter

abhijitnalekar — Mon, 04 Oct 2021 11:57:33 GMT

Hi @Shrikant ,

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

Re: Load on a filter

Shrikant — Mon, 04 Oct 2021 11:59:39 GMT

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

Re: Load on a filter

abhijitnalekar — Mon, 04 Oct 2021 12:12:03 GMT

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.

Re: Load on a filter

Shrikant — Tue, 05 Oct 2021 04:25:25 GMT

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

Re: Load on a filter

Shrikant — Tue, 05 Oct 2021 04:31:26 GMT

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

Re: Load on a filter

abhijitnalekar — Tue, 05 Oct 2021 07:09:48 GMT

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