topic Re: Calendar selection in QlikView

Calendar selection

Tue, 19 Nov 2013 17:42:01 GMT

calendar before selection

Calendar after selection

I want the august month in the same, with and without selction...

Re: Calendar selection

Anonymous — Tue, 19 Nov 2013 17:45:20 GMT

Reddy

In the List Box, Sort tab ensure State is unticked and sort by Numeric Value Ascending, assuming your Month is in QlikView Date format.

Best Regards, Bill

Re: Calendar selection

MK_QSL — Tue, 19 Nov 2013 17:46:43 GMT

GO TO SORT TAB

LOAD ORDER ORIGINAL

Re: Calendar selection

MayilVahanan — Tue, 19 Nov 2013 17:48:42 GMT

Try like this

Properties -> Sort -> State-> AutoAscending -- uncheck

Numberic Value -> Ascending

Re: Calendar selection

Tue, 19 Nov 2013 18:08:37 GMT

Here i am just using the load inline for my calendar and sorting

[Month Sorting]:

Load * Inline
[Month,Month Sort
JAN, 01
FEB, 02
MAR, 03
APR, 04
MAY, 05
JUN, 06
JUL, 07
AUG, 08
SEP, 09
OCT, 10
NOV, 11
DEC, 12
];

Re: Calendar selection

Anonymous — Tue, 19 Nov 2013 18:10:37 GMT

Reddy

Then sort by Expression :

[Month Sort]

Best Regards, Bill

Re: Calendar selection

Tue, 19 Nov 2013 18:20:18 GMT

@Bill Markham yes did the same ..but when selected the month changing the position ..please find screen shot

Re: Calendar selection

Anonymous — Tue, 19 Nov 2013 18:22:11 GMT

Reddy

Can you post a sample qvw ?

Best Regards, Bill

Re: Calendar selection

israrkhan — Tue, 19 Nov 2013 18:25:01 GMT

its very simple..

properties>> general tab>> check Show as Tree View...

done

Re: Calendar selection

preminqlik — Tue, 19 Nov 2013 18:34:14 GMT

OPEN LIST BOX PROPERTIES AND WRITE THE FOLLOWING EXPRESSION IN SORTING :

only({1}Month)

-Many Thanks

Premhas.

Re: Calendar selection

Tue, 19 Nov 2013 18:37:55 GMT

IsrarKhan tanq