Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
entsh
Contributor II
Contributor II

Set Analysis be applied to drill down dimension

hello

i use drill down chart

for actual and plan  collective sales amount (month 2 =month1+2,month 3=month 1+2+3,....)

for actual sales i use this formula and its worked but current month is 3 and after that the numbers are repeated(see the attachment)

round(Range Sum (Above(sum( sales),0,Row No())),1)

how can i fix that ?i want dimension shows number until current date

(when i click the number it shows week and the it show days) so in each steps show data until today

 

3 Replies
entsh
Contributor II
Contributor II
Author

in fact i want the numbers in dimention show until there is a data for that,and dont repeat the last data for next month or week or day

sunny_talwar

May be this

If(Sum(sales) <> 0, 
  Round(
    RangeSum(Above(Sum(sales), 0, RowNo()))
  , 1)
)
entsh
Contributor II
Contributor II
Author

 its getting better  thx but

If(Sum([sales) <> 0, Round( RangeSum(Above(Sum([sales)), 0, RowNo())) , 0)

actual must be :

1= 128            2= 667           3=...

but now

1= ...          2= 128             3=667

one  back!