topic Re: When selecting more than 6 months, current selection box is showing the month not selected in QlikView

When selecting more than 6 months, current selection box is showing the month not selected

Wed, 13 Jun 2012 07:52:29 GMT

Hi All,

I have attached a applicaion, in which i have created a straight table with some details. When i select first 6 months (Jan till June) the table is showing the details for the selected month. But when i select more than 6 months( example Jan till july) it is showing the month which are not selected. How can i fix this.

Regards,

Gerard

Re: When selecting more than 6 months, current selection box is showing the month not selected

christophebrault — Wed, 13 Jun 2012 08:12:10 GMT

Hi,

You can fix this in User Preference (Ctrl+Alt+U)\General

Look on the right for search parameters and rise max number of value in active selections.

Re: When selecting more than 6 months, current selection box is showing the month not selected

hic — Wed, 13 Jun 2012 08:14:21 GMT

The "Current Selections" object is designed to show the selection as compact as possible. So, with 6 values selected it shows "Jan, Feb, Mar, Apr, May, Jun" and with 7 values selected it shows "NOT Aug, Sep, Oct, Nov, Dec". This is the way it should be.

However, you can change the threshold where it toggles over to showing excluded values: Under "Settings- User Preferences" you should change "Max Values in Current Selections".

HIC

Re: When selecting more than 6 months, current selection box is showing the month not selected

Wed, 13 Jun 2012 09:18:13 GMT

Thanks ,its working. Now i changed the properties and i can able to see the current selection for all the months. Also fixed the issue for the straight table by using conditional expression SubStringCount(GetFieldSelections(Month,',',100),'Jan')>0

Re: When selecting more than 6 months, current selection box is showing the month not selected

Thu, 31 Oct 2013 08:33:27 GMT

Hi henric,

even after changing this setting in user preferences, it works fine at the client side but not on the server.

It still shows 'NOT'. Is this a bug ?

Any help ?

Regards

Re: When selecting more than 6 months, current selection box is showing the month not selected

hic — Thu, 31 Oct 2013 11:12:09 GMT

No, the content of the object is calculated on the server, so it picks up the settings on the server, not on the client.

HIC

Re: When selecting more than 6 months, current selection box is showing the month not selected

Fri, 01 Nov 2013 06:21:40 GMT

Hi,

thanks for the reply.

what should i do to make it work on the server, any setting in the QMC ?

Regards