Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
win_anthony
Partner - Contributor III
Partner - Contributor III

Creating Dynamic Label/Title if Bookmarked Filter is Active/Deactivated

I currently have a bookmarked filter that is active. The goal is to create a dynamic label that will react if the bookmarked filter is either active or deactivated. Is it possible to create a dynamic label in a master item if I have a bookmarked filter that is currently active but will react when deactivated? Below is an example.

Active Bookmarked Filter Ex: Filter = Pineapple Pizza? >  Yes
Active Bookmarked Filter Ex: Label = "Yes, I love Pineapple Pizza!"

Deactivated Bookmarked Filter Ex: Filter = Pineapple Pizza? > No
Deactivated Bookmarked Filter Ex: Label = "No, are you crazy? You never put Pineapple on Pizza!"

Is this possible for master item labels? How would you create a syntax that would make this work? 

Labels (1)
1 Solution

Accepted Solutions
win_anthony
Partner - Contributor III
Partner - Contributor III
Author

I was overthinking this and quickly found a solution: 

= IF( [Pineapple Pizza?] = 'Y', 'Yes, I love Pineapple Pizza!', 'No, are you crazy? You never put Pineapple on Pizza!'  ) 

View solution in original post

1 Reply
win_anthony
Partner - Contributor III
Partner - Contributor III
Author

I was overthinking this and quickly found a solution: 

= IF( [Pineapple Pizza?] = 'Y', 'Yes, I love Pineapple Pizza!', 'No, are you crazy? You never put Pineapple on Pizza!'  )