Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

PLS EXPLINATIN ABOUT THIS EXPRESSION?

Pls give me explination about this expression

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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

3 Replies
sasikanth
Master
Master

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

Pick function pics the corresponding value

Not applicable
Author

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
Master
Master

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