Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Edit Expression

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

Re: Edit Expression

Shows blank

Re: Edit Expression

What is the format of the field Packed?

Not applicable

Re: Edit Expression

2017-06-12 00:00:00

Datetime stamp

Re: Edit Expression

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

Re: Edit Expression

Same thing blank

sasiparupudi1
Honored Contributor III

Re: Edit Expression

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

Re: Edit Expression

Well I get a zero now

Re: Edit Expression

Would you be able to share a sample?

Community Browser