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: 
raviityou
Partner - Creator
Partner - Creator

Accumulation

Hi All,

I am facing an issue to accumulation of Vendor count I am using calculated dimension for range and I have count of it based on that.

I am using the =RangeSum (Above( Count(DISTINCT (Vendor)),0,RowNo())) but it not working its showing the same result as it counting of vendor.

Please find the Screen shot of it.

Thanks …..!@

101
1 Solution

Accepted Solutions
swuehl
MVP
MVP

Are you using two dimensions? Then you may need to use the TOTAL qualifier, like

RangeSum (Above(TOTAL Count(DISTINCT (Vendor)),0,RowNo(TOTAL)))

View solution in original post

1 Reply
swuehl
MVP
MVP

Are you using two dimensions? Then you may need to use the TOTAL qualifier, like

RangeSum (Above(TOTAL Count(DISTINCT (Vendor)),0,RowNo(TOTAL)))