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: 
ch_riadh
Partner - Creator II
Partner - Creator II

Date Set analysis

Hi guys.

I did a Master Calendar work fine.

In my Expression i have to use 'Postdate'. it Works Fine. with this expression :

Sum({$<Postdate ={">=$(=MonthStart(varSelectDate))<=$(=varSelectDate)"}>} Value_Exp))

But when i Select 2 month, it gave me the data for the last month, i want the data for 2 months.

exp:

FEB = 20

MAR: 10

When i select feb and mar he give me only 10 , But i i need 30.

I know that the problem is related to Monthstart but i don't know how i can resolve it.
plz need help emergency.

thanks






1 Reply
tresesco
MVP
MVP

Define your variables like:

varSelectDateMin = Date(Min(Postdate))

varSelectDateMax = Date(Max(Postdate))

And expression like:

Sum({$<Postdate ={">=$(=MonthStart(varSelectDateMin))<=$(=varSelectDateMax)"}>} Value_Exp))

But eventually(if you are supposed to select in the month field) it seems to be equivalent to simple: Sum(Value_Exp)