topic Re: Calendar object is not working for Alternate State? in QlikView

Calendar object is not working for Alternate State?

Fri, 29 Nov 2013 13:25:58 GMT

Hi Community,

May I know why the calendar object is not working properly for alternate state?

Alternate state is working for list box selection as well as the chart.

But when i try to select 2 different period (Analysis and Comparator), it will follow the latest date selection only...

Attached herewith the .qvw file for troubleshooting reference.

Kindly assist.

Thanks and best regards,

Chanel

Re: Calendar object is not working for Alternate State?

Anonymous — Fri, 29 Nov 2013 13:58:47 GMT

Channel

In your Calendar Objects, Presentation tab, for Data try selecting Field ShortCreatedDate instead of a variable.

Best Regards, Bill

Re: Calendar object is not working for Alternate State?

Fri, 29 Nov 2013 14:07:12 GMT

Hi Bill,

Thanks for fast response!
I tried to go to General tab -> Data -> field -> ShortCreatedDate, it is not working because there is no start and end date for ShortCreatedDate.

Thanks and best regards,

Chanel

Re: Calendar object is not working for Alternate State?

Anonymous — Fri, 29 Nov 2013 14:31:47 GMT

Chanel

It works fine for me.

What kind of 'not working' are you experiencing ?

Best Regards, Bill

Re: Calendar object is not working for Alternate State?

Fri, 29 Nov 2013 14:42:28 GMT

Hi Bill,

yupe, firstly i am unable to select a Start analysis date and end analysis date separately.

I could drag the date range like this, but there might be more than 1000 days. It is a good idea to drag date like this.

A new problem raised is if i selected a date range, calendar object will show something meaningless like "---"

Thanks and best regards,

Chanel

Re: Calendar object is not working for Alternate State?

Anonymous — Fri, 29 Nov 2013 17:47:37 GMT

Chanel

I see what you after now [I hope]

Is the attached qvw more what you are after ?

Best Regards, Bill

Re: Calendar object is not working for Alternate State?

Clever_Anjos — Fri, 29 Nov 2013 19:12:15 GMT

It´s not a problem of calendar.

You´re using variables.

Variables are not 'copied' to Alternate States.

They´re always related to Default State

Re: Calendar object is not working for Alternate State?

Fri, 29 Nov 2013 20:42:32 GMT

Just what Clever said. If you have differente states, you need same variables for these states.

Example:

Sheet1 = firstAlternateState

Then you need vStartDateFirstAlternateState and vEndDateFirstAlternateState

Sheet2 = SecondAlternateState

Then you need vStartDateSeondAlternateState and vEndDateSecondAlternateState

And so forth.

Re: Calendar object is not working for Alternate State?

Sat, 30 Nov 2013 04:21:47 GMT

Hi Clever,

Thanks for the explanation, but my variable will trigger the field which is set in document properties.

Best regards,

Chanel

Re: Calendar object is not working for Alternate State?

Sat, 30 Nov 2013 04:25:15 GMT

Awesome Bill!
I think I just missed out the format of date in variable trigger.

Thanks and best regards,

Chanel

Re: Re: Calendar object is not working for Alternate State?

Anonymous — Sat, 30 Nov 2013 10:14:29 GMT

Chanel

No worries, Those date formats certainly can be slippery blighters.

Your Variables vs. Alternate States were all correct & sound, as you already had specific Variables dedicated to specific States.

Sorry I got a bit confused about things earlier.

Best Regards, Bill Markham