Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott2
Creator
Creator

Pass the date entered by the user from QlikSense Custom Object "date picker" on GUI into an expression on a pivot table

 

 

 

 

 

Labels (2)
4 Replies
Or
MVP
MVP

I don't quite understand your question. This is something that should happen automatically - when a user picks a date, everything is filtered based on this date (assuming your schema has this date field connected to the rest of the app, anyway). This is no different than filtering on any other field in your app.

Scott2
Creator
Creator
Author

Hi Or, thanks for getting back to me on this. 

I dont want to connect my date picker to a data field in the data I have loaded. I want to pass the date the user selects into a variable so that I can use that variable to do a more complex filter on my data than would be possible if i connected the date picker field directly to one of the date fields in the data i have loaded.

Hope that makes sense?

Thanks again

Scott 

Or
MVP
MVP

It makes sense, but unfortunately, the bundled date picker doesn't allow for variables, I believe. Past that, if you were to use a third-party extension or a Variable Input, this would be used the same as any other variable - the fact that it's a date doesn't really change anything. How you'd use it in your expressions depends on what you'd want it to do, exactly.

Scott2
Creator
Creator
Author

thanks for your reply. In case others trying to do the same come across this post in the future:

1. Variable Input Custom object works fine other than not providing a date picker. I pass into my expressions to apply my complex filter.

2. I found this widget https://github.com/NickAkincilar/QlikDatePickerWidget which would have worked perfectly but i see widgets have since been deprecated which is a really disappointing move by Qlik as they were clearly very useful https://community.qlik.com/t5/Official-Support-Articles/Deprecation-Notice-Qlik-Sense-Widgets-and-Cu...

I have posted this on the relevant board to see if has been recreated 

https://community.qlik.com/t5/Integration-Extension-APIs/QlikDatePickerWidget-replaced-in-an-extenti...

 

3. 3rd party extension - there seems to be various calendar extensions but i havent yet found the one that does what i need. I will post back here if i find one.