Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sujeetsingh
Master III
Master III

Straight table Help

Hello All,

I am struck up in a small expression.

I am using s straight table where i have a calculated dimension

FirstSortedValue(Brand,-[SaleDate] & BrandID & [RowNo()])) as primary dimension  and Year as secondary dimension.

Now i need to calculate average as

Brand   Year    Count( distinct BrandID)      Avg

Levis    2011         2                                  2/2+3+7

Lee      2011         3                                   3/2+3+7

Mufti    2011         7                                   7/2+3+7

1 Solution

Accepted Solutions
sujeetsingh
Master III
Master III
Author

Achieved it with Range sum and rank function.

View solution in original post

4 Replies
Not applicable

Have you checked with Total, Count(distinct BrandID)/count(Total Distinct BrandID).

hariprasadqv
Creator III
Creator III

Hi,

Write Expression for average in Expressions tab.sum(Values)/Count(Values)

Thanks

sujeetsingh
Master III
Master III
Author

I want the total at each row

sujeetsingh
Master III
Master III
Author

Achieved it with Range sum and rank function.