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
Hello
Can you develop a sample table for clarity sake?
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 ?
I will suggest you use a master calendar for this work.
Follow this link: How to use - Master-Calendar and Date-Values
Looks my response was helpful. You can tag it 'helpful'
Regards
under adds on, uncheck show zero values
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
that is true , but i want the values for the weekend which is zero , i need to omit only that part
that is true , but i want the values for the weekend which is zero , i need to omit only that part
could you make an example ?