Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

moslem_teymoori
Contributor

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
Contributor II

Re: How to filter in scripting based on date

Hello

Can you develop a sample table  for clarity sake?

moslem_teymoori
Contributor

Re: How to filter in scripting based on date

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
Contributor II

Re: How to filter in scripting based on date

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

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

akpofureenughwu
Contributor II

Re: How to filter in scripting based on date

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

Regards

OmarBenSalem
Esteemed Contributor

Re: How to filter in scripting based on date

under adds on, uncheck show zero values

pawwy1415
Contributor II

Re: How to filter in scripting based on date

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
Contributor

Re: How to filter in scripting based on date

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

moslem_teymoori
Contributor

Re: How to filter in scripting based on date

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

moslem_teymoori
Contributor

Re: How to filter in scripting based on date

could you make an example ?

Community Browser