Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Display sums by date dimension

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 

 

DateCount
6/1/20191
6/2/20192
6/3/20193
6/4/20194
6/5/20195
6/6/20196
6/7/20197
6/8/20198
6/9/20199
6/10/201910
6/11/201911
6/12/201912
6/13/201913
6/14/201914
6/15/201915
6/16/201916
6/17/201917
6/18/201918

 

My Expected result is

DateCnt-CurrentCount To Date
6/18/201918171

 

Any suggestions would be highly appreciated.