Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

autopilot
Contributor III

Current Selections Display Issue

In the application, I have a standard current selections box. My problem is that users do not like when they select all but a few, or all the values in a field that the current selections box will display "NOT value, value, value" or "ALL".

I've attached an image of issue if the above explanation or example below is not clear.

Does anyone know how I can make it so that if they make selections in a field (let's say Month) with the values equal to everything but one that it will show every value selected rather than NOT value? Is this possible?

EXAMPLE:

Field = Month

Values = Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec

User selections in field = Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep

Display in Current Selections box = "NOT Oct, Nov, Dec"

Desired Display in Current Selections box = "Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep"

Thanks!

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Current Selections Display Issue

Well, there is nothing you can do on the Current Selection object itself.  But you can do something for pdf printing.

In the print dialog, go to Header/Footer.  Here you can use any section of header or footer for your purpose, just enter something like this:

='Months: ' & GetFieldSelections(Month, '; ', 12)

And, click "Save Settings" so you don't need to do it every time.

Regards,

Michael

6 Replies
mov
Esteemed Contributor III

Re: Current Selections Display Issue

Try to increas "Max Values in Current Selections" in User Preferences.  Keep in mind thta it is a property of user environment, not of QV application.

Another approach - use text box instaed, with functions getfieldselections()

Regards,

Michael

autopilot
Contributor III

Re: Current Selections Display Issue

Thank you. I was reviewing my post right before your reply when I noticed this discussion in the "More Like This" window...http://community.qlik.com/message/227838#227838

This works great and is exactly what I was looking for .... but it doesn't appear to function for applications opened from a server deployment.

Am I doing something wrong or is this a limitation?

Thanks!

autopilot
Contributor III

Re: Current Selections Display Issue

I tried using the getfieldselections() and getcurrentselections() in a text box prior and it showed the same (reduced) display of selected values in a field(s).....is there a parameter that can be set with either of these functions which will change the output (like the max values in current selections property does)?

autopilot
Contributor III

Re: Current Selections Display Issue

Ok I looked up the help file and saw that there is a parameter to set the max values for the functions used in list box - which does work even in server deployments.....

Still interested in knowing if there is a way to include this feature for the current selections object. The objective for users is to include it in when they print a chart object (to excel or pdf) where all the values are displayed.

mov
Esteemed Contributor III

Re: Current Selections Display Issue

Well, there is nothing you can do on the Current Selection object itself.  But you can do something for pdf printing.

In the print dialog, go to Header/Footer.  Here you can use any section of header or footer for your purpose, just enter something like this:

='Months: ' & GetFieldSelections(Month, '; ', 12)

And, click "Save Settings" so you don't need to do it every time.

Regards,

Michael

autopilot
Contributor III

Re: Current Selections Display Issue

Thanks, Michael! This works great!

I appreciate your helpful input.

Community Browser