topic Re: Calendar object in QlikView

Calendar object

Mon, 24 Mar 2014 08:35:02 GMT

Hello everyone,

I have two calendar object, and I want to make every time I open report first object to show me first date of current month and the second object to show me last date of current month like on picture below. I create two varible and in first i put expression like this Num(MonthStart(Today())) but if I change starting date and reopen report he always remember last date.

I guess this is not a problem. Hope you can help me.

Thansk

Re: Calendar object

its_anandrjs — Mon, 24 Mar 2014 08:43:38 GMT

Hi,

use Variable like

vStartDate = Num(MonthStart(Today()))

and use this in object.

Hope this helps

Thanks & Regards

Re: Calendar object

Mon, 24 Mar 2014 08:57:37 GMT

Hi Anand,

Thanks for your reply, it helped me. I realized that he remember last state of object and he will change it on starting date of month only if I reload the script. I thought to have start of month when I open QlikView.

Re: Calendar object

jsingh71 — Mon, 24 Mar 2014 09:06:23 GMT

Hi Stefan,

Find Attachment, may be it will solve your problem.

Re: Calendar object

its_anandrjs — Mon, 24 Mar 2014 09:07:29 GMT

Hi,

Thanks but i believe it depends on your system available dates also any function not depends on state of object and when you reload the application the current date will be latest date and time that you reload.

Hope this helps

Thanks & Regards

Re: Calendar object

Mon, 24 Mar 2014 09:46:13 GMT

Can I add some trigger which will on open document reload that calendar object?