Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
akpofureenughwu
Creator III
Creator III

Hello

Can you develop a sample table  for clarity sake?

Anonymous
Not applicable
Author

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 ?

akpofureenughwu
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

akpofureenughwu
Creator III
Creator III

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

Regards

OmarBenSalem
Partner - Champion II
Partner - Champion II

under adds on, uncheck show zero values

pawwy1415
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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

could you make an example ?