Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone explain what are the limitations of valuelist()/ valueloop().
If you use ValueList as Calculated Dimension or as an Inline Iceland table there would be no difference in performance.
Inline Load is only to avoid duplicate written statement of ValueList using nested IFs.
Valuelist with many values and data having millions rows will give you poor performance but If there is no alternative for showing KPIs except ValueList function, one can take risk using it...
Inline load will give you advantage of KPI selection.
With ValueList you are UNABLE to make a selection, but with inline you would be ABLE to make a selection.