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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to hide particular date/year on slider and list box

Hi,

I am working on application where I need to hide a particular date and year from showing itself in date slider and list box. How to achieve this? Do I need to write the expression for this? Is there an easy way to achieve this?

Abhijit

1 Solution

Accepted Solutions
neelamsaroha157
Specialist II
Specialist II

I am not sure of any other way but you can try the expression in list box

If(not Match(Year, 'x','y'), year

OR

You can creat this expression in your script as well and use that column in front end instead of regular year

View solution in original post

4 Replies
Anil_Babu_Samineni

What you mean of particular date and year. Can you explain more

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

Suppose I have a table with columns Id, Date. And my date column contains the dates like 03/01/1900, 03/02/1900, 03/02/2015, 03/04/2016. In my date slider I want to show all the dates but not 03/01/1900 and 03/02/1900. But that data will be present in the dataset. I just don't want to show it in slider and in list box. How to achieve this?

Abhijit

neelamsaroha157
Specialist II
Specialist II

I am not sure of any other way but you can try the expression in list box

If(not Match(Year, 'x','y'), year

OR

You can creat this expression in your script as well and use that column in front end instead of regular year

Not applicable
Author

Thank you Neelam.