Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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 ? 

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Or in your script, throw out all future years (those you do not want to see) from your MasterCalendar.

Or change your pivot table expression into:

money(

(Sum({<year = {"<=$(=Year(Today()))"},

       $(ColumnDim51)={$(ColumnDim51)}>} Amount)/$(Columndim89)/1000)

, $(vMoneyFormatK))

This will eliminate all data from the next year and later. Change to whatever cut-off year you like.

Peter

View solution in original post

14 Replies
Chanty4u
MVP
MVP

u want to hide column? or    data?   is it dimension?

sunny_talwar

Use a calculated dimension instead of YearMonth field as dimension -> If(YearMonth <= Today(), YearMonth)

Chanty4u
MVP
MVP

if its dimension

=if(Dim1=Dim2, null(),'')


supress nul values and hide dimension in  presentation tab

Anonymous
Not applicable

may be in date column have data

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Or in your script, throw out all future years (those you do not want to see) from your MasterCalendar.

Or change your pivot table expression into:

money(

(Sum({<year = {"<=$(=Year(Today()))"},

       $(ColumnDim51)={$(ColumnDim51)}>} Amount)/$(Columndim89)/1000)

, $(vMoneyFormatK))

This will eliminate all data from the next year and later. Change to whatever cut-off year you like.

Peter

MayilVahanan

Hi

Try like this

Calculated Dimension

=If(Year <= Year(Today()), YearMonth)

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

try this expression

If(YearMonth <= Today(), YearMonth)

paulyeo11
Master
Master
Author

Hi All

Thank you very much for all your sharing , it work fine.

Paul

paulyeo11
Master
Master
Author

Hi All

Now i make my table more flexible . by insert diamension :-

=$(ColumnDim_p)

May i know how to remove 2030 Dec ?

Paul