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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide rows in a chart table using conditionals

Hi,

I hope someone can help me. I'm trying to hide rows within a chart table when a condition is true.

I have one dimension called Employee and one of my expresions is LeaveDate.

Basically I need to hide all those rows where LeaveDate < Today()

How can I do that?

I have tried using the conditional field in the Dimensions tab but it didn't make any difference.

Any ideas would be appreciated.

Thanks a lot.

1 Solution

Accepted Solutions
MayilVahanan

HI

     Use if(LeaveDate < Today(),express) in all expression, it will hide the values..

     or use set analysis in expressions..

     Make sure, both leavedate and today() are in same format.

     Hope it helps

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

2 Replies
giakoum
Partner - Master II
Partner - Master II

sum({$<[LeaveDate]={"<$(=Today())"}>} [Some Field])

Maybe Suppress When Value Is Null check is also needed (Dimensions tab of chart)

MayilVahanan

HI

     Use if(LeaveDate < Today(),express) in all expression, it will hide the values..

     or use set analysis in expressions..

     Make sure, both leavedate and today() are in same format.

     Hope it helps

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