Qlik Community

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 
Search instead for 
Did you mean: 
shiveshsingh
Master
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
kristof_j
Creator II
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

View solution in original post

2 Replies
kristof_j
Creator II
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
shiveshsingh
Master
Master
Author

Thanks, got it!