Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

How to filter in scripting based on date

Hello Qlikers 
I am using Qlik sense Desktop version. I want to filter the date on the graph to be greater than a specific day. any hint guys?
or what if i want to create a master method to do that for me ? any hints?T

Thank you so much

9 Replies
Highlighted
Creator III
Creator III

Hello

Can you develop a sample table  for clarity sake?

Highlighted
Creator
Creator

2018-05-02_17h55_00.jpg

Here is tha table , and i do not want to uncheck "include the null values" in the property panel or i do not want to put a where condition in the sql code, , i just want to eliminate these dates using scripting  , any Idea my friend ?

Highlighted
Creator III
Creator III

I will suggest you use a master calendar for this work. 

Follow this link: How to use - Master-Calendar and Date-Values

Highlighted
Creator III
Creator III

Looks my response was helpful. You can tag it 'helpful'

Regards

Highlighted
Partner
Partner

under adds on, uncheck show zero values

Highlighted
Creator III
Creator III

Hi,

In the Measure try like below

sum( {$<[Date]={"=Len(trim([Date]))>0"}>}[Net Sales])

So it will display only value bars by avoiding zeros

Highlighted
Creator
Creator

that is true , but i want the values for the weekend which is zero , i need to omit only that part 

Highlighted
Creator
Creator

that is true , but i want the values for the weekend which is zero , i need to omit only that part 

Highlighted
Creator
Creator

could you make an example ?