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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Possible hide column with date 2030 Dec ?

Hi All

My pivot table appear a date 2030 Dec, which is wrong date.. May i know it is possible make it disappear ? 

14 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Either in your Calculated Dimension replace YearMonth with your new dimension specification $(ColumnDim_p), or - as the previous may lead to unexpected expansions (you don't know what's inside variable ColumnDim_p) - throw the 03 DEC value out in your expression, as shown here: Re: Possible hide column with date 2030 Dec ?

sunny_talwar

This still seems to work -> =If($(ColumnDim_p) <= Today(), $(ColumnDim_p))

paulyeo11
Master
Master
Author

Hi Sunny

Thank you , but when i change the Year , 2030 still appear.

Paul

paulyeo11
Master
Master
Author

Hi Peter

Your expression work fine . Thank you very much.

Paul

paulyeo11
Master
Master
Author

Hi Sunny

Peter Expression work fine. He try to do the filter those date which is higher then today.

Paul