topic Re: Re: Multiple Selection Within a Field in QlikView

Multiple Selection Within a Field

jduenyas — Mon, 03 Nov 2014 04:36:54 GMT

Hi all

I have created a macro to select multiple months within a YearMonth field (2013 Dec, 2014 Jan ... etc) that contains a list of rolling months.

The macro is being called from 3 buttons for most commonly selected months ie. YTD (Jan through current month) , last 6 months and last 12 months which can span over 1 or 2 years.

Is it possible to do this selection without using a macro? (using QV built in functionality and probably variables(?))

Actions in a button allow to Select in Field whereas a field can be specified but how can a specify a range of months?

Thanks

PS the macro I have created works fine but reading some "bad" things about macros I am trying to learn the "correct" ways of moving around

All the best

Josh

Re: Multiple Selection Within a Field

jagan — Mon, 03 Nov 2014 05:20:05 GMT

Hi,

Can you attach a sample file? You can achieve this by using Select in Field trigger with Concat and set analysis.

Regards,

jagan.

Re: Multiple Selection Within a Field

ashfaq_haseeb — Mon, 03 Nov 2014 05:23:58 GMT

Hi,

You can try like this

(Value1|Value2)

Regards

ASHFAQ

Re: Re: Multiple Selection Within a Field

jduenyas — Mon, 03 Nov 2014 06:06:52 GMT

How should the Concat work in an Action command?

Attached is a sample

Thanks

Re: Re: Multiple Selection Within a Field

jduenyas — Mon, 03 Nov 2014 06:07:54 GMT

See my replay to Jagan

A sample is attached following your suggestion but it doe not work.

Thanks

Re: Re: Multiple Selection Within a Field

its_anandrjs — Mon, 03 Nov 2014 06:10:25 GMT

In Search string write (A|D) with open and close brackets.

Regards

Anand

Re: Multiple Selection Within a Field

jagan — Mon, 03 Nov 2014 06:12:05 GMT

Hi Jost,

You need to give below as Search String then it works.

(A|B|C|D)

Regards,

jagan.

Re: Re: Multiple Selection Within a Field

jduenyas — Mon, 03 Nov 2014 06:13:54 GMT

Actually it does work.

Before I did not have the parenthesis but after adding them it does work.

(What difference do the parenthesis do?)

Thanks

Re: Re: Multiple Selection Within a Field

jagan — Mon, 03 Nov 2014 06:20:49 GMT

Hi,

The syntax is like that, you have to give Parenthesis. If you do not give then Qlikview considers it as Syntax error.

Regards,

Jagan.

Re: Multiple Selection Within a Field

b_garside — Wed, 13 May 2015 16:07:57 GMT

Is there a way to do this with Concat function, but allow values that have spaces?

Right now I cant get concat to do ("Value One"|"Value Two") instead it does (Value On|Value Two) which wont work unless the values have no spaces. (ValueOne|ValueTwo) need syntax to add quotes around the strings.

Re: Multiple Selection Within a Field

b_garside — Wed, 13 May 2015 16:46:45 GMT

I found what I needed. '(' & Concat(DISTINCT chr(39) & Field & chr(39) , '|' ) & ')'