Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
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
sureshqv
Esteemed Contributor III

Re: Possible hide column with date 2030 Dec ?

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

Re: Possible hide column with date 2030 Dec ?

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

sureshqv
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

vsudhakar
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

Re: Possible hide column with date 2030 Dec ?

Hi

Try like this

Calculated Dimension

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

vsudhakar
Contributor III

Re: Possible hide column with date 2030 Dec ?

try this expression

If(YearMonth <= Today(), YearMonth)

paulyeo11
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

paulyeo11
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

Community Browser