topic How to max calendar object order by today first in QlikView

How to max calendar object order by today first

Tue, 07 Jun 2011 13:04:39 GMT

Does anyone know how to make my calendar object show today first when the field is blank, I have tried all several expression sort orders but still getting Oct 2008 instead of today

Any help would be great

Thanks

Andy

How to max calendar object order by today first

Miguel_Angel_Baeyens — Tue, 07 Jun 2011 13:09:42 GMT

Hello Andy,

Do you mean sort your chart descending by date when there are no dates selected? Have you tried as expression just the date field name?

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

How to max calendar object order by today first

Tue, 07 Jun 2011 13:22:30 GMT

Hi Miguel

I use a island table to create from and start date calendar objects that set a variable to apply to charts. If the calendar object is empty then the first date the object shows is Oct 2008, the clients wants today (June 2011) to be shown on selection. I have set the select field on a button to today and that works but if someone clears the selectiosn then I'm back to 2008

Hope that helps and thanks for the reply

Andy

How to max calendar object order by today first

Miguel_Angel_Baeyens — Tue, 07 Jun 2011 13:36:56 GMT

Hello Andy,

Did you try to use Max(DateFieldInIsland) as expression in the sort by / descending dialog?

It would help if you could post some dummy data in an actual file.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: How to max calendar object order by today first

Mon, 13 Jun 2011 10:15:51 GMT

Hi Miguel

Sorry for the delay. Please find example attached. Trying to get the Calendar Icon to default to Today's Month when field is empty.

Thanks

Andy

How to max calendar object order by today first

Miguel_Angel_Baeyens — Mon, 13 Jun 2011 11:12:22 GMT

Hello Andy,

There's no attached file. Anyway, you can use an action or trigger so when the document is opened, Selection, Select in Field, Field Name Month (or your actual month field name) and "=Month(Today())" (without quotes) as the query string.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

How to max calendar object order by today first

Mon, 13 Jun 2011 11:15:59 GMT

File is now attached. I use tiggers on open and also on a reset button but its when users use the clear button that I have the issue.

Thanks for the answers so far

Andy

How to max calendar object order by today first

Miguel_Angel_Baeyens — Mon, 13 Jun 2011 12:33:56 GMT

Hello Andy,

That clear button may have another action, after clearing all selections, to likewise select the current month in the month field, is that right?

Regards,

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

How to max calendar object order by today first

Mon, 13 Jun 2011 12:45:30 GMT

Hey

I would just like the sort order to be Today (Decending) on first click of the item, I can do this via tiggers but they dont cover all situations. I have tried a few SORT expression but with no look.

Thanks

Andy

Re: How to max calendar object order by today first

Miguel_Angel_Baeyens — Mon, 13 Jun 2011 13:12:05 GMT

Hello Andy,

Try going to the calendar object properties, Sort tab, and check Numeric Value -> Descending and Expression -> Descending with the following

If(StartDate <= Today(), StartDate, false())

This should show first, in descending order, all the dates starting today backwards, then all remaning dates in the field in descending order.

Is that what you are looking for?

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: How to max calendar object order by today first

Mon, 13 Jun 2011 14:21:56 GMT

Miguel

that great for the drop down section of the object but still no change from the calendar icon on the object.

Andy

Re: How to max calendar object order by today first

Miguel_Angel_Baeyens — Mon, 13 Jun 2011 14:32:03 GMT

Hello Andy,

That icon will always show all possible values for the field specified, unless a selection is done, in that case all other objects will be affected by that selection.

I don't know of any "default value" setting in the calendar object when you click on the calendar icon. But using a variable instead of the field may do the trick.

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica