Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
vvvvvvvvvv
Creator
Creator

Create bookmark by using formula

venus_0-1589520396565.png

I have a if condition in showing the review yr dimension in table.

And I want to create a default bookmark by input formula in search in table.
Since I use the if condition in dimension so I cannot use review_yr in the search directly.
How can I input the formula in search in the table so that I can search desired year using formula?

venus_1-1589520475896.png

 

 

Labels (4)
1 Solution

Accepted Solutions
vvvvvvvvvv
Creator
Creator
Author

should create a table with multiple columns [Review_yr, Type, xxxxxxxx]

Then, input the formula according to the column like review_yr = '2017-2018' in review_yr column, type='HR' in type column.

When input all formula , save the bookmark

View solution in original post

3 Replies
tresesco
MVP
MVP

Try like:

=Review_Yr='2017-2018'

 

 

vvvvvvvvvv
Creator
Creator
Author

no, since there are other filters applying to the review_yr field.

It is not work when only review_yr=2017-2018

vvvvvvvvvv
Creator
Creator
Author

should create a table with multiple columns [Review_yr, Type, xxxxxxxx]

Then, input the formula according to the column like review_yr = '2017-2018' in review_yr column, type='HR' in type column.

When input all formula , save the bookmark