Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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

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 ?