topic PLS EXPLINATIN ABOUT THIS EXPRESSION? in QlikView

PLS EXPLINATIN ABOUT THIS EXPRESSION?

Wed, 25 Jun 2014 05:39:02 GMT

Pls give me explination about this expression

'pick(match(Metric,' & peek('AllMetrics') & '),' & peek('AllExpressions') & ')';

sasikanth — Wed, 25 Jun 2014 05:52:48 GMT

Here Metric is a filed with that it will match the parameters based on selection

Pick function pics the corresponding value

Wed, 25 Jun 2014 05:55:48 GMT

Hi sasi,

Metric is field and it will get the result based on expression

Here my question is what is the meaning of writing

& peek('AllMetrics') & '),' & peek('AllExpressions') & ')' using and symbols

Pls give me some more clarification

i am very much thankful to u

sasikanth — Wed, 25 Jun 2014 06:40:19 GMT

HI manoj

Usaually & symbol is used for concatination, means

='text'&peek(Exp)

in the above if you place & then only the function will be evaluated

If the symbol is not within the codes(out side of quotes)

Here it is inside, no matter whatever is there in Quotes it will display as usual

please check quotes once