topic Explain about caliculated dimenstions in QlikView

Explain about caliculated dimenstions

gkcchowdary — Wed, 25 Nov 2020 16:16:04 GMT

Witch scenario using calculated dimensions,and explained value list and value loop

Re: Explain about caliculated dimenstions

Chanty4u — Thu, 07 Apr 2016 07:55:58 GMT

chk dis

Missing Manual - ValueLoop() & ValueList()

How To /Missing Manual (24 articles)

Calculated Dimensions

Re: Explain about caliculated dimenstions

HirisH_V7 — Thu, 07 Apr 2016 10:14:47 GMT

Hi,

Check this,

ValueList() – For those tricky situations

Use Case for ValueList Chart Function

In ValueList() you give a list explicitly separated by comma, like ValueList(V1, V2, .....), while in ValueLoop() you can give starting and ending values and third parameter to tell the step. That means, if you write valueLoop(10, 20, 2), you get values string from 10 and ending at 20 with gap of 2, so the output : 10,12,14,16,18,20. In short, In ValueLoop() you have to setup a rule to generate values, whereas in ValueList() you have to mention the values itself.

HTH,

PFA,

Hirish