Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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!