topic Re: Creating Calendar Object In Qlikview in QlikView

Creating Calendar Object In Qlikview

s10157754 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Creating Calendar Object In Qlikview

s10157754 — Fri, 05 Jan 2018 06:37:34 GMT

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

Re: Creating Calendar Object In Qlikview

susovan — Fri, 05 Jan 2018 07:40:14 GMT

Hi,

You can also try this

=num(sum({<Date={">=$(SelectDateFrom)<=$(SelectDateTo)"},Month=,Quarter=,Year=>} Value),'#,##0')