topic Re: Hide rows in a chart table using conditionals in QlikView

Hide rows in a chart table using conditionals

Wed, 12 Sep 2012 13:38:35 GMT

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.

giakoum — Wed, 12 Sep 2012 13:42:52 GMT

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

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

MayilVahanan — Wed, 12 Sep 2012 13:45:11 GMT

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