Display sums by date dimension

SRG — Wed, 25 Nov 2020 16:16:04 GMT

HI,

I have a requirement to display countsfor last 10 days. For example my date dimension would be currentdate through currenrtdate-10. I created a variable saying date dimension between currentdate and currentdate-10 and used the same in the set expression which is working fine. I need to create another measure showing MonthTo date for the same 10 days. I created a variable with date dimension between Monthstart of currentdate and currentdate and used in the set expression. However my date dimension values are not limiting to 10 meaning date dimension are populating from 1st day of the month to currentdate. Is there a way to still limit the dimension values to 10 days in the charts. For example

Date	Count
6/1/2019	1
6/2/2019	2
6/3/2019	3
6/4/2019	4
6/5/2019	5
6/6/2019	6
6/7/2019	7
6/8/2019	8
6/9/2019	9
6/10/2019	10
6/11/2019	11
6/12/2019	12
6/13/2019	13
6/14/2019	14
6/15/2019	15
6/16/2019	16
6/17/2019	17
6/18/2019	18

My Expected result is

Date	Cnt-Current	Count To Date
6/18/2019	18	171

Any suggestions would be highly appreciated.

topic Display sums by date dimension in QlikView

Display sums by date dimension