Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, any one can help with this questions, thanks.
I am trying to build a filter that can help get all data from a start date to an end date instead of using '>=1/6/2015<=1/10/2015' in
the search input box
Hi Jane,
If I am understanding your requirement correctly, you are looking for date picker in qliksense.
This can be done using extension in qliksense
Below is the extension link for your reference.
Regards,
Akshaya
Hi,Akshaya,thanks for help! I am wondering if we can set the date range by using coding in master calendar. Not sure if it is possible or we only can apply the extension!Thanks!
Sent from my iPhone
Hi Jane,
If you let me know the whole scenario, I will help you better However selecting dates using date picker works fine and it will work faster.
Regards,
Akshaya
Hi, Akshaya, really appreciated. I don't think the company that I worked in has the date picker extension of Qlik.
Here is the scenario, I have the date filter, then I can get the revenue on a specific day, lets say 6/25/2017.
If I wanna check the total revenue from 6/25/2017 to 7/26/2017,or any range between two dates. How can I set the filter instead of scrolling down all the way in the date filter.
Thanks,
Jin
Hi Jane,
If you don't want to use the extension, then you need to
- Create two island tables with single Column , one with Start and and other End date.
- Create two variables and provide values using getFieldSelection function.
- Use these variables in expression within set analysis.
Hope this helps. Let me know if you need dummy application for reference.
Regards,
Akshaya
Hi, Akshaya, since the Qlik tech support in our company said that the extension is not stable....no idea...Your method sounds great, but I am new to qlik, still under learning. Could you please share some sample codes?
Really appreciated!