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: 
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






Labels (1)
1 Reply
tresB
Champion III
Champion III

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)