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

Edit Expression

How can I add the Packed > 2017-06-12 00:00:00 to the logic below?

sum(If(Packed> '2017-06-12 00:00:00',Lables))

(Sum(if(Left(FormName,3)='Tab', Lables)))+(Sum(if(Left(FormName,3)='Cap', Lables)))-(sum(if(PartialTablet=-1, Lables)))

10 Replies
sunny_talwar

May be this?

Sum({<FormName = {'Tab*', 'Cap*'}, Packed = {"=$(='>=' & Date(MakeDate(2017, 6, 12), 'YYYY-MM-DD hh:mm:ss'))"}>} Lables) - Sum({<PartialTablet = {-1}, Packed = {"=$(='>=' & Date(MakeDate(2017, 6, 12), 'YYYY-MM-DD hh:mm:ss'))"}>} Lables)

Not applicable
Author

Shows blank

sunny_talwar

What is the format of the field Packed?

Not applicable
Author

2017-06-12 00:00:00

Datetime stamp

sunny_talwar

Can you try this

RangeSum(

Sum({<FormName = {'Tab*', 'Cap*'}, Packed = {"=$(='>=' & Date(MakeDate(2017, 6, 12), 'YYYY-MM-DD hh:mm:ss'))"}>} Lables),

-Sum({<PartialTablet = {-1}, Packed = {"=$(='>=' & Date(MakeDate(2017, 6, 12), 'YYYY-MM-DD hh:mm:ss'))"}>} Lables)

)

Not applicable
Author

Same thing blank

sasiparupudi1
Master III
Master III

May be try this

=sum({<FormName={'Tab*','Cap*'},Packed={'>2017-06-12 00:00:00'}>}Lables)-sum({<PartialTablet={'-1'},Packed={'>2017-06-11 00:00:00'}>}Lables)

Not applicable
Author

Well I get a zero now

sunny_talwar

Would you be able to share a sample?