topic Re: Formatting of Current Selections in QlikView

Formatting of Current Selections

Fri, 03 Oct 2014 15:29:48 GMT

Please see attached. Using a trigger on document open, I'm selecting all the (completed) months to date. The problem is how it appears in the Current Selections box. The parentheses-contained, pipe-delimited, alphabetized list doesn't look as clean as the default.

To be specific, when the document opens, I see this in Current Selections:

MonthName: (Apr|Aug|Feb|Jan|Jul|Jun|Mar|May|Sep)

I'd like to see the default that appears when I select those months manually -- that is, a chronological, comma-separated list (with or without NOT consistent with the default behavior).

If I'm stuck with that formatting, I'd like to at least see the months in chronological order.

Thanks.

Re: Formatting of Current Selections

antoniotiman — Fri, 03 Oct 2014 15:49:46 GMT

Hi Brian,

in your action in open, in expression Concat add MonthNo after '|'

Concat(......... distinct MonthName,'|',MonthNo)

MonthNo in Concat is field sort

Regards,

Antonio

Re: Formatting of Current Selections

Gysbert_Wassenaar — Fri, 03 Oct 2014 16:37:23 GMT

See attached qvw.

Re: Formatting of Current Selections

Fri, 03 Oct 2014 17:21:46 GMT

Two good answers. Thank you both.

Re: Formatting of Current Selections

mikecrengland — Fri, 03 Oct 2014 18:02:38 GMT

You actually solved a problem that I was struggling with! I wanted to use a variable to select less than some amount in one of my fields and used your suggestion to do it on the variable update... ='<'&$(vFinalMPH)

I tried just about everything except what you suggested... Thanks!

mike

Re: Formatting of Current Selections

brian554xx — Mon, 01 May 2017 18:37:06 GMT

This is magnificent. Thank you!

Thought I would suggest my preferred sort order:

State Ascending (not auto ascending)
Expression Only({1} MonthNo)