Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kavieweg
New Contributor II

Rangsum of values for each day separately

Hi Togehter,

i wolud like to use this working Statement for every day in my data_table. If i pick one day, everything is fine. If I pick more than one day, than i dont want a rangesum over all values of all days.

rangesum( above(SUM({$<[Order Type]={'A'}, [Category]={'COLLECTED'}>} [TOTAL_WEIGHT]),0,rowno()))

Thanks for helping.

Mathias

4 Replies
mdmukramali
Valued Contributor II

Re: Rangsum of values for each day separately

Hi,

Can you attach sample data file.

kavieweg
New Contributor II

Re: Rangsum of values for each day separately

Datetime / DimensionOrder IDdateweight in kgWhat i want
What i get
rangesum
01.03.2018 12:00A01.03.20182000
01.03.2018 12:30B01.03.201882020
01.03.2018 12:45C01.03.2018192828
01.03.2018 13:00D01.03.2018274747
02.03.2018 10:00E02.03.20186074
02.03.2018 11:45F02.03.20188680
02.03.2018 12:00G02.03.2018211488
......

Re: Rangsum of values for each day separately

Not Really sure, Your Open question, Perhaps this?

If(GetSelectedCount(Date)>1, SUM({$<[Order Type]={'A'}, [Category]={'COLLECTED'}>} [TOTAL_WEIGHT]), rangesum( above(SUM({$<[Order Type]={'A'}, [Category]={'COLLECTED'}>} [TOTAL_WEIGHT]),0,rowno())))

If This is in Pivot Table, You can try like

Sum(Aggr(If(GetSelectedCount(Date)>1, SUM({$<[Order Type]={'A'}, [Category]={'COLLECTED'}>} [TOTAL_WEIGHT]), rangesum( above(SUM({$<[Order Type]={'A'}, [Category]={'COLLECTED'}>} [TOTAL_WEIGHT]),0,rowno()))), Date, .....)

Re: Rangsum of values for each day separately

May be this

Aggr(RangeSum(Above(Sum({$<[Order Type] = {'A'}, [Category] = {'COLLECTED'}>} [TOTAL_WEIGHT]), 0, RowNo())), date, Datetime))

Community Browser