Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlikview Experts,
I have look through some discussion related to calendar object creation in Qlikview. I have also follow the instructions step by step on how to create a calendar object. But it just not working in my dashboard. I hope anyone of you can help me solve this problem.
Basically right now I have created 2 variables "SelectDateFrom" & "SelectDateTo" respectively. I have also assigned expression for these 2 variables under trigger tab in document properties. But after I created two calendar objects and select a specific date frame, it just not showing any data in current selection box. So I know there must be something I missed out.
I had attached the Qlikview file for your reference. Any ideas would be greatly appreciated!
Best Regards,
QianNing
Hi All. I Had solved the problem.
It looks like for whatever reason my variables are coming back in a number format vs date format. So I try forcing the search string to come back in the date format. So something like:
='>=' & Date(SelectDateFrom) & '<=' & Date(SelectDateTo)
Thanks for your precious time!
Best Regards,
QianNing
Hi,
You can also try this
=num(sum({<Date={">=$(SelectDateFrom)<=$(SelectDateTo)"},Month=,Quarter=,Year=>} Value),'#,##0')