# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for
Did you mean:
Master

## Dimensionality Code

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,

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

1 Solution

Accepted Solutions
Creator II

Maybe this will help

What does the TOTAL qualifier do?

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:

• Berlin always 5 (the total)
• London always 6
• Paris always 7
2 Replies
Creator II

Maybe this will help

What does the TOTAL qualifier do?

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:

• Berlin always 5 (the total)
• London always 6
• Paris always 7
Master
Author

Thanks, got it!