topic Add field selection in QlikView

Add field selection

Mon, 16 Jun 2014 11:36:42 GMT

Hi everyone,

I'm trying to extend a selection on a field by clicking a button. I defined an action on the field [FInicio EjercicioMes]:

='(' & concat(distinct chr(34) & [FInicio EjercicioMes] & chr(34), '|') & '|' &

concat(distinct chr(34) & p({1<[PeriodoTAM2]={1}>} [FInicio EjercicioMes]) & chr(34), '|')

& ')'

so, my aim is to mantain the current selection of [FInicio EjercicioMes] and add those [FInicio EjercicioMes] with [PeriodoTAM2]={1}.

I am not sure if there is a grammar mistake or I took a wrong way...

Thanks in advance.

Marc.

Re: Add field selection

tresB — Mon, 16 Jun 2014 11:39:56 GMT

Try:

='(' & concat(distinct chr(39) & [FInicio EjercicioMes] & chr(39), '|') & '|' &

concat(distinct {1<[PeriodoTAM2]={1}>} chr(39)& [FInicio EjercicioMes] & chr(39), '|')

& ')'

Re: Add field selection

Mon, 16 Jun 2014 11:47:11 GMT

The result is like a clear: nothing selected on [FInicio EjercicioMes]...

Re: Add field selection

tresB — Mon, 16 Jun 2014 11:48:29 GMT

Use the above expression in a text box and see the output string. How does it look?

Re: Add field selection

Mon, 16 Jun 2014 12:02:26 GMT

I obtained different formats from each concat values. I've modified the expression:

='(' & concat(distinct chr(39) & date(MonthName([FInicio EjercicioMes]),'MM-YYYY') & chr(39), '|') & '|' &

concat(distinct {1<[PeriodoTAM2]={'1'}>} chr(39)& date(MonthName([FInicio EjercicioMes]),'MM-YYYY') & chr(39), '|')

& ')'

and the string is: ('01-2014'|'02-2014'|'04-2014'|'05-2014'|'06-2014') , where the two first values are the selection and the other three are the wanted addition. But it doesn't work... same result: nothing selected.

Re: Add field selection

tresB — Mon, 16 Jun 2014 12:31:34 GMT

Try without chr(39). Single quotes are causing the issue.

='(' & concat(distinct date(MonthName([FInicio EjercicioMes]),'MM-YYYY') , '|') & '|' &

concat(distinct {1<[PeriodoTAM2]={'1'}>} date(MonthName([FInicio EjercicioMes]),'MM-YYYY') , '|')

& ')'

Re: Re: Add field selection

Mon, 16 Jun 2014 12:37:39 GMT

same result. I add a qvw example...

Re: Re: Re: Add field selection

tresB — Mon, 16 Jun 2014 13:24:30 GMT

The field value is actually numeric. Your format changing has caused the issue. Expression should be:

='(' &

concat( {$+1<[PeriodoTAM2]={1}>} distinct ([FInicio EjercicioMes]), '|')

& ')'

Note: $ -> denotes current selection. This makes your expression simpler.

Re: Re: Add field selection

Tue, 17 Jun 2014 06:18:41 GMT

It works fine. Thank you!