Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

stekol61
Contributor

Open document for specific Countries

Hi!

When I open the document I want if to show data for specific countries, e.g LT and NO.

How do I do this?

9 Replies
Employee
Employee

Re: Open document for specific Countries

Same procedure of this Open document on current year

Employee
Employee

Re: Open document for specific Countries

Checking your screenshot, there´s no data related to LT and NO on 2017/08 is it correct?

vinieme12
Esteemed Contributor II

Re: Open document for specific Countries

use the OnOpen trigger to select the values in the field automatically aftr opening the document

Document Properties: Triggers ‒ QlikView

stekol61
Contributor

Re: Open document for specific Countries

I added a OnOpen trigger as below but it doesn't seem to work

MVP
MVP

Re: Open document for specific Countries

The search string should be (NO|LT)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
stekol61
Contributor

Re: Open document for specific Countries

(NO|LT) works but if i add a third country e.g (NO|LT|DK) it doesn't work

prieper
Honored Contributor II

Re: Open document for specific Countries

Should work,
is there data for DK within the selection?

MVP
MVP

Re: Open document for specific Countries

That is the correct syntax. Please say what part "doesn't work".

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
stekol61
Contributor

Re: Open document for specific Countries

Need to study the data more in detail in order to see what's wrong.

In the mean time, as a workaround, I select all countries manually before I save the report.

Community Browser