Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Help please: My result is time frame insensitive.

='Total lbs Shipped: ' & num(if([Date Filter] = 'Both',

                                                                                sum({<[Ship Date] = p(Date)> + <[Delivery Date] = p(Date)> + $<Carrier = {Boutin} >}lbs),

                                                                                if([Date Filter] = 'Delivery',

                                                                                          sum({<[Delivery Date] = p(Date)> + $<Carrier = {Boutin} >}lbs),

                                                                                          sum({<[Ship Date] = p(Date)> + $<Carrier = {Boutin} >}lbs))), 

                                                                      '##,###.')& ' Lbs'

im working for a trucking company, this is my code above, im trying to find out the volume we carry with our carrier "Boutin", but the result turn out to be time frame insensitive, doesnt matter how i change the time frame, the result doesnt change at all.

please someone help me~~~

1 Solution

Accepted Solutions
Not applicable

Re: Help please: My result is time frame insensitive.

Do you have a sample file? With only the expression and no indication of your data model or the contents of your Date Filter and such, it isn't much to go on. I'm assuming you want it to filter based on date and it does not currently?

2 Replies
Not applicable

Re: Help please: My result is time frame insensitive.

Do you have a sample file? With only the expression and no indication of your data model or the contents of your Date Filter and such, it isn't much to go on. I'm assuming you want it to filter based on date and it does not currently?

Not applicable

Re: Help please: My result is time frame insensitive.

Hi Rebecca, i already fixed the problem, i forgot to use quote on my selection...