Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 (1)
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