Discussion board where members can get started with Qlik Sense.
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.
Go to Solution.
1) In Script
Load * inline [
Resident TabDate where Not IsNum(Date);
Drop Table TabDate;
2) In frontend:
=If(Not IsNum(Date),Date) as Calculated Dimension in Filterpane
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 )