Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
heena_shaikh
Contributor II
Contributor II
‎2017-05-09 05:05 AM

Removed

 
351 Views
0 Likes
4 Replies
Anil_Babu_Samineni
MVP
MVP
‎2017-05-09 05:14 AM

Try to do it Expression for RangeAvg like

RangeAvg(Field1, Field2 ...Fieldn)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
278 Views
0 Likes
heena_shaikh
Contributor II
Contributor II
‎2017-05-09 05:25 AM
Author

 
278 Views
0 Likes
jonathandienst
Partner - Champion III
Partner - Champion III
‎2017-05-09 05:58 AM

In response to heena_shaikh

You can use the function Dimensionality() to have the expression dependant on the dimension level.

=If(Dimensionality() = 1, <expression for dimension level 1>, ....)

If the dimensions are across the top, then you should use SecondaryDimensionality() instead.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
278 Views
0 Likes
Anil_Babu_Samineni
MVP
MVP
‎2017-05-09 06:44 AM

In response to heena_shaikh

Okay, Then please provide sample data

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
278 Views
0 Likes