Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
tenyeapen
Contributor
Contributor
‎2020-10-12 02:33 AM

set condition for entire dashboard

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

797 Views
0 Likes
1 Solution

Accepted Solutions
MayilVahanan
MVP
MVP
‎2020-10-12 05:57 AM

In response to tenyeapen

HI

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) 

mayilvahanan_0-1602496517786.png

In that , create action like below. 

mayilvahanan_1-1602496593591.png

Remember: FieldName & FieldValues are case sensitive. 

Similarly, for sheet action also.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

744 Views
0 Likes
4 Replies
FakeJupiter
Creator
Creator
‎2020-10-12 02:54 AM

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.

781 Views
0 Likes
tenyeapen
Contributor
Contributor
‎2020-10-12 04:17 AM
Author

In response to FakeJupiter

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

758 Views
0 Likes
MayilVahanan
MVP
MVP
‎2020-10-12 05:57 AM

In response to tenyeapen

HI

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) 

mayilvahanan_0-1602496517786.png

In that , create action like below. 

mayilvahanan_1-1602496593591.png

Remember: FieldName & FieldValues are case sensitive. 

Similarly, for sheet action also.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
745 Views
0 Likes
Brett_Bleess
Former Employee
Former Employee
‎2020-10-27 10:44 AM

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...

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Button2.htm#anc...

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Document_Proper...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
710 Views
0 Likes