topic Re: display on a current Selection Object in QlikView

display on a current Selection Object

josephinetedesc — Thu, 14 Jul 2016 01:45:31 GMT

Hi I have a list box which shows the months - I used an expression:

=Monthname(date(dateQA))

When I thing choose a month from this list box - the Current Selections box show the selection as 623 of 4380 o r 618 or 4380 etc

Is there something I can do about this? It is correct but users are thrown off by the fact that it is not showing what they selected ie May 2016.

Thank you

o\Jo

Re: display on a current Selection Object

tamilarasu — Thu, 14 Jul 2016 02:32:00 GMT

Hi Josephine,

Follow the below steps.

Menù -> User preferences --> General -> Max Values in Current Selections -> Max limit is 100 (Distinct values will be shown in current selection box).

Re: display on a current Selection Object

josephinetedesc — Thu, 14 Jul 2016 02:46:46 GMT

Sorry Tamil I have not explained myself well:

the list box shows the Months in the format of Apr 2016 but the selection box does not show Apr 2016 it will show 208 of 3043. 208 of 3043 are the number of individual dates in April 2016.

So in the original document dateQA is a datestamp (there are 3043 dates in this instance) - in the Lilstbox - the datestamps are grouped according to the monthname - so for example in April - there were 208 dateQA datestamps and they are grouped under the monthname which is displayed. The Selection box however does not show the monthname date group, but tells me that I have 208 dates. Hope that makes sense.

Jo.

Re: display on a current Selection Object

vishsaggi — Thu, 14 Jul 2016 03:04:14 GMT

May be create a new field in your script like

Load col1,

col2,

dateQA,

date(monthstart(DateQA), 'MMM-YYYY') as MonthYear

FROM ...... ;

And create MonthYear listbox.

Just a thought!!!

Re: display on a current Selection Object

josephinetedesc — Thu, 14 Jul 2016 03:10:52 GMT

Re: display on a current Selection Object

josephinetedesc — Thu, 14 Jul 2016 03:13:44 GMT

This is what I mean - the list box is fine (showing the edited expression), but the Current Selections box is confusing - although correct.

Re: display on a current Selection Object

tamilarasu — Thu, 14 Jul 2016 03:30:32 GMT

Hi Josephine,

As mentioned by Vishaggi, create a new field in back end and use the field name in listbox.

Re: display on a current Selection Object

NZFei — Thu, 14 Jul 2016 04:12:14 GMT

The current selection box is showing the current selections by fields. The only field that you have selected is dateQA so it only shows dateQA. If you create a field called "MonthName" in the script and then make selection in the front in this field, it will show May 2016 in the current selection box.

The calculation "=Monthname(date(dateQA))" is not a field.

Hope that can help.

Fei

Re: display on a current Selection Object

josephinetedesc — Thu, 14 Jul 2016 13:58:49 GMT

Thank you