RangeSum() and RowNo() - Qlik Community

nictheswede · ‎2018-02-02

Hi

I use the following expression to add the first % to the next and so on:

rangesum(Above(([Sales]/AGGR(NODISTINCT SUM([Sales]),PG)),0, RowNo()))

When i choose another dimension (KC) in addition to PG I would like to keep the same percentages as i had when only PG was chosen but sort out KC.

I tried to add a SET to the expression but the it will only count the visable results.

rangesum(Above(([Sales]/AGGR(NODISTINCT SUM({<KC=>}[Sales]),PG)),0, RowNo()))

I hope my explanation is somewhat understandable.

sunny_talwar · ‎2018-02-02

Try this

RangeSum(Above(([Sales]/Only({<KC>}AGGR(NODISTINCT SUM({<KC=>}[Sales]),PG))), 0, RowNo()))

nictheswede · ‎2018-02-05

I tried your suggestion but it didn´t give the answer I was looking for.

The diagram shows all the rows but it doesn´t count the values.

This example, I think, explains how I mean:

I would like the expression to do this:

But I get:

sunny_talwar · ‎2018-02-05

May be you need this

RangeSum(Above(Only({<KC>}[Sales]), 0, RowNo()))/Sum(TOTAL <PG> [Sales])

qliksus · ‎2018-02-05

Maybe something like this

sum(aggr(rangesum( Above(sum({1}per),0,Rowno(total))),PG,ID))

nictheswede · ‎2018-02-26

Thanks for your input but it won´t work for me.

I don´t get the values that I sorted out to add when they are not visible.

nictheswede · ‎2018-02-26

Thanks for your input but it won´t work for me.

I don´t get the values that I sorted out to add when they are not visible.

sunny_talwar · ‎2018-02-26

Okay ... not sure how to help without looking at this... more than happy to help if you are able to share a sample

nictheswede · ‎2018-02-27

My goal is to make work just like a filter in Excel.

I would like to keep the Ack% for each ID but when i choose KC I get a new value based on the new conditions.

I would like the expression to do this:

But I get:

sunny_talwar · ‎2018-02-27

I give up...

Someone else might be able to help you better.

Best,

Sunny