Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

Hardcoded object selection

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?

3 Replies
Highlighted

Re: Hardcoded object selection

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

Highlighted
Honored Contributor

Re: Hardcoded object selection

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

Highlighted
Contributor

Re: Hardcoded object selection

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.