topic Re: access point issue in QlikView

access point issue

Anonymous — Mon, 15 Sep 2014 04:57:44 GMT

Hi community experts,

I have created one list box with year field.when i open the application by default it has to select year 2014.for that i did the triggers like this

Settings->document properties-triggers->Document event triggers->on open ->added the action like select in field(in field box given Year and in search string box given =Max(Year).)

when i open the application in my desktop its working fine but in access point its not working and 2014 year is showing before 2012.

but it has to appear like 2012

2013

2014

Please give the reply very urgent .

Thanks,

krishna.

Re: access point issue

Mon, 15 Sep 2014 04:59:35 GMT

if not work, then try same on sheet properties of Active sheet.

Re: access point issue

Anonymous — Mon, 15 Sep 2014 05:05:55 GMT

thanks vishwa its working but 2014 is coming first row of list box .it has to appear 2012,2013,2014 but its appearing like this 2014,2012,2013 in access point .

Thanks,

krishna

Re: access point issue

Mon, 15 Sep 2014 05:16:26 GMT

selected data always show in first row in list box.

if you deselect then it appear 2012 2013 2014 like this.

Re: access point issue

Anonymous — Mon, 15 Sep 2014 05:21:58 GMT

my first selection is year only.after i deselect also its showing like 2014,2012,2013

Re: access point issue

Mon, 15 Sep 2014 05:24:56 GMT

set this field in ascending order .

go to its properties

sort tab

check numeric value in ascending order

Re: access point issue

PrashantSangle — Mon, 15 Sep 2014 05:26:06 GMT

Hi,

What is your sort order for Year List box??

Try State-Asending

Numeric Value: ascending

Regards

Re: access point issue

tresB — Mon, 15 Sep 2014 05:27:20 GMT

Goto Sort tab->Uncheck 'State' and check 'Numeric Value' ->Ascending

Re: access point issue

er_mohit — Mon, 15 Sep 2014 05:38:05 GMT

Hi Try this

in sort tab for Year Field

Only check for State-- Ascending. Save it then open the application

Re: access point issue

Anonymous — Mon, 15 Sep 2014 05:38:20 GMT

i applied all the conditions above but its working in my Desktop but its not appearing in access point .

Re: access point issue

Anonymous — Mon, 15 Sep 2014 05:38:56 GMT

i applied all the conditions above but its working in my Desktop but its not appearing in access point .

Re: access point issue

ashfaq_haseeb — Mon, 15 Sep 2014 05:41:25 GMT

Hi,

Go to sort tab and select sort by numerical value.

Regards

ASHFAQ

Re: access point issue

Anonymous — Mon, 15 Sep 2014 05:41:52 GMT

i applied all the conditions above but its working in my Desktop but its not appearing in access point .

Re: access point issue

dinuwanbr — Mon, 15 Sep 2014 05:44:02 GMT

Dear Krishna,

Sort your Year value as Text to A-Z and Check.

BR,

Dinu1

Re: Re: access point issue

tresB — Mon, 15 Sep 2014 05:56:30 GMT

After making the changes in the document, save it in the server. Goto access point, refresh the state by clicking 'Remove last document state' and then retry to open the app.