topic Re: Variable with Concat into Set Analysis in QlikView

Variable with Concat into Set Analysis

Fri, 20 Feb 2015 14:36:51 GMT

I've a variable called vTest = Concat(DISTINCT {$<FlagCY={1},M.FECHA={">=$(#desde)<=$(#hasta)"},M.NIVEL1 ={'01'},M.RESPUESTA ={'Si'},M.MARCA = p(MARCALEVADURA_T)>} ID_SITIO,',')

This vTest output is 15073,15074

I've just created another var called vTest2 = '15073,15074'

Then i've a chart witt the followings expresion :

sum({$<ID_SITIO = {'$(=$(vTest))'},M.MARCA = p(MARCALEVADURA2_T)>} CANTIDADLEVADURA)

sum({$<ID_SITIO = {'$(=$(vTest2))'},M.MARCA = p(MARCALEVADURA2_T)>} CANTIDADLEVADURA)

An its not working with neither both options

If ihardcode this :

sum({$<ID_SITIO = {'15073,15074'},M.MARCA = p(MARCALEVADURA2_T)>} CANTIDADLEVADURA)

Works fine.

Any idea?

Thanks

Albert

Re: Variable with Concat into Set Analysis

Fri, 20 Feb 2015 14:46:25 GMT

Sorry,

The hardcoded expresion should be

sum({$<ID_SITIO = {15073,15074},M.MARCA = p(MARCALEVADURA2_T)>} CANTIDADLEVADURA)

WITHOUT SIMPLE QUOTES

Thanks

Re: Variable with Concat into Set Analysis

Anonymous — Fri, 20 Feb 2015 14:55:30 GMT

It happens sometime and annoying to find out the real reason. Most of the time problems lie with quotes, Dollar sign, or equal to sign. Could you please try once removing = sign from the variables where you created that. If it is there then try by removing it. It's not a solution just some random trial. If u share with your app, I could try help you more efficiently.

Re: Variable with Concat into Set Analysis

Anonymous — Fri, 20 Feb 2015 14:57:23 GMT

Try to use double quotes here:

= {"$(=$(vTest))"}

Re: Variable with Concat into Set Analysis

Anonymous — Fri, 20 Feb 2015 15:01:04 GMT

Hmm, from the description it is not clear if there is '=' sign in the variable definition. Very possible it maybe a reason.

Re: Variable with Concat into Set Analysis

Fri, 20 Feb 2015 15:03:38 GMT

The varible is defined without the equalbefore Concat

Re: Variable with Concat into Set Analysis

Fri, 20 Feb 2015 15:15:17 GMT

when vTest returns just one element, the expresion is working fine, if returns more than one, fails.

Re: Variable with Concat into Set Analysis

Anonymous — Fri, 20 Feb 2015 15:21:19 GMT

It helps. See if the hardcoded this way works (each value in single quotes)

{'15073','15074'}

If it works, modify your variable to enclose each value in the single quotes. Again, I recommend to use double quotes as in my earlier post.

Re: Variable with Concat into Set Analysis

Fri, 20 Feb 2015 15:30:58 GMT

Problem Solved.

The problem was that concat was returning the list of values, without quotes in the numbers

i've use : ' "," ' as concat separator, in order to have the list of values separated by commas and surronded with quotes.

Thanks to all.

Albert