Re: Please anyone suggest,What is the exact use of valuelist() and valueLoop() in qlikview.
For example, create a calculated dimension in a straight table:
Then, an expression like
You'll get a dimension with two value, KPI1 and KPI2. To check in your expression, which is the current dimension value, you'll need to repeat the Valuelist() function as used in the dimension again in the expression. (Above can also be written as