topic Re: set condition for entire dashboard in QlikView

set condition for entire dashboard

tenyeapen — Wed, 25 Nov 2020 16:16:04 GMT

I have a dashboard with 4 queries and many charts, I need to give condition globally like "division = north".

kindly help me how to set that

FakeJupiter — Mon, 12 Oct 2020 06:54:22 GMT

Hi there,

Why just no use a filter for that page?
Add action for the Sheet to select division = north, and clear the filter when you leave the sheet.

tenyeapen — Mon, 12 Oct 2020 08:17:37 GMT

I'm new to Qlikview, so can u please let me know how to do this?

MayilVahanan — Mon, 12 Oct 2020 09:58:04 GMT

There are several ways based on the requirement.

If you want to apply globally while open the app itself, please try like below
go to Document Properties -> Trigger -> OnOpen (Event Trigger)

In that , create action like below.

Remember: FieldName & FieldValues are case sensitive.

Similarly, for sheet action also.

Brett_Bleess — Tue, 27 Oct 2020 14:44:44 GMT

Just adding a couple of Help Doc links, as some Actions/Triggers are not supported in Ajax client as an FYI, so be sure to review the information...

Regards,
Brett