# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Valued Contributor II

## 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

## Re: Possible hide column with date 2030 Dec ?

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

14 Replies
Esteemed Contributor III

## Re: Possible hide column with date 2030 Dec ?

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

MVP

## Re: Possible hide column with date 2030 Dec ?

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

Esteemed Contributor III

## Re: Possible hide column with date 2030 Dec ?

if its dimension

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

supress nul values and hide dimension in  presentation tab

Contributor III

## Re: Possible hide column with date 2030 Dec ?

may be in date column have data

## Re: Possible hide column with date 2030 Dec ?

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

MVP

## Re: Possible hide column with date 2030 Dec ?

Hi

Try like this

Calculated Dimension

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

Contributor III

## Re: Possible hide column with date 2030 Dec ?

try this expression

If(YearMonth <= Today(), YearMonth)

Valued Contributor II

## Re: Possible hide column with date 2030 Dec ?

Hi All

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

Paul

Valued Contributor II

## Re: Possible hide column with date 2030 Dec ?

Hi All

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

=\$(ColumnDim_p)

May i know how to remove 2030 Dec ?

Paul