topic Dimensionality Code in QlikView

Dimensionality Code

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

Please help me in understanding below code line by line and also logic of putting Total<>,Total<>,Total<>,Total<> in numr and denominator

Pick(Dimensionality()+1,

Sum(TOTAL <>

{<PeriodType={'$(Period)'},=, ,,,=p()>}$(Value))

Sum(TOTAL {<PeriodType={'$(Period)'},=,=,,,, =p()>}$(Value)),

Sum(TOTAL <>

{<PeriodType={'$(Period)'},=,,,=p()>}$(Value))

Sum(TOTAL <>

{<PeriodType={'$(Period)'},=,=,,,, =p()>}$(Value)),

Sum(TOTAL <>

{<PeriodType={'$(Period)'},=,,=p()>}$(Value))

Sum(TOTAL <>

{<PeriodType={'$(Period)'},=,=,,,,=p()>}$(Value)),

Sum(TOTAL <>

{<PeriodType={'$(Period)'},=,=p()>}$(Value))

Sum(TOTAL <>

{<PeriodType={'$(Period)'},=,=,,,,=p()>}$(Value)))

kristof_j — Thu, 08 Mar 2018 08:40:00 GMT

Maybe this will help

If you add a dimension to your total then you calculate the total on each value of that dimension.

In the article above if you write 'total <City>' then you'll get for:

shiveshsingh — Thu, 08 Mar 2018 09:46:01 GMT

Thanks, got it!