Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
bhavvibudagam
Contributor II

How to remove 5 from the date field

Hi Experts,

Can any one please help me on this.

In the below date field I am getting 5,6 from the excel source file load.

Please help me on deleting 5,6 from the filter pane in the front end. I cant delete in the backend.

Thanks in advance.

1 Solution

Accepted Solutions
pritamb89
Contributor

Re: How to remove 5 from the date field

1) In Script

TabDate:

Load * inline [

Date,

2012-01,

2012-02,

2012-03,

2012-04,

2013-01,

2013-02,

2013-03,

2013-04,

5,

6

];


TabDate2:

NoConcatenate

Load

Date

Resident TabDate where Not IsNum(Date);

Drop Table TabDate;

Capture2.PNG


2) In frontend:

=If(Not IsNum(Date),Date) as Calculated Dimension in Filterpane

2 Replies
MVP
MVP

Re: How to remove 5 from the date field

You can filter out the values that should be shown in the filter pane by using an expression.

=If( Date >= MakeDate(2015,1,1) , Date )

pritamb89
Contributor

Re: How to remove 5 from the date field

1) In Script

TabDate:

Load * inline [

Date,

2012-01,

2012-02,

2012-03,

2012-04,

2013-01,

2013-02,

2013-03,

2013-04,

5,

6

];


TabDate2:

NoConcatenate

Load

Date

Resident TabDate where Not IsNum(Date);

Drop Table TabDate;

Capture2.PNG


2) In frontend:

=If(Not IsNum(Date),Date) as Calculated Dimension in Filterpane