Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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






4 Replies
sushil353
Master II
Master II

Hi,

create two variables as

vMindate = Min(Date)

vMaxDate = Max(Date)

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

HTH

Sushil

ch_riadh
Partner - Creator II
Partner - Creator II
Author

Thank you
Done

sushil353
Master II
Master II

Hi,

if you issue is resolved then mark this thread as answered so that other get benefited.

Thanks

ch_riadh
Partner - Creator II
Partner - Creator II
Author

Srry but Still the isuue with this expression.

count({$<DATE2={">=$(=MonthStart(vMinDate))<=$(=vMaxDate)"}>}

if(Month(vMaxDate) =Month(InvoiceDate) ,VehicleNumber ))