topic Re: Hardcoded object selection in QlikView

Hardcoded object selection

stekol61 — Mon, 04 Sep 2017 08:27:51 GMT

Hi!

I have a report where you can select data for different Countries (see below).

A new requirement is to create duplicates of the same report, one for each country.

So if you use the report for e.g. FI you should not be able to see or select data for any other country.

The current Country listbox will be removed.

I have tried to use a hidden listbox where a country is selected but I'm not sure if it's the best way to solve this?

Re: Hardcoded object selection

avinashelite — Mon, 04 Sep 2017 09:21:37 GMT

share the sample app , that will help us to understand better

Re: Hardcoded object selection

effinty2112 — Mon, 04 Sep 2017 11:11:27 GMT

Hi Stefan,

Use you existing qvw as a source for a binary load. For your qvw for FI copy the existing qvw and replace the load script with a binary load statement.

Add this simple macro to the new qvw.

sub ReduceData()

ActiveDocument.ReduceData

end sub

Add an OnOpen trigger with two actions.

1. Select in field Country, Search String FI.

2. RunMacro - ReduceData.

Good luck

Andrew

Re: Hardcoded object selection

stekol61 — Tue, 05 Sep 2017 07:23:12 GMT

Hi!

I will use one load script for data for all countries and i prefer not to chang this.

I have used a hidden filter in the report where one country is selected and I think that this will work good enough.