Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
moslem_teymoori
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
akpofureenughwu
Creator III
Creator III

Hello

Can you develop a sample table  for clarity sake?

moslem_teymoori
Creator
Creator
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

moslem_teymoori
Creator
Creator
Author

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

moslem_teymoori
Creator
Creator
Author

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

moslem_teymoori
Creator
Creator
Author

could you make an example ?