topic Re: Quantity sum <= today in QlikView

Quantity sum <= today

Thu, 21 Jul 2016 15:49:58 GMT

Hi,

I am trying to sum QTY for week_min_date <= today and other conditions.

But, the date condition is not working.

Please Help ASAP.

Thanks,

Rahul

Sum({$<date[week_min_date]={">=$((today()))"},week_flag={'P'},week_Act={'Discharging'}, LocationId={250} >} QTY)

Re: Quantity sum <= today

Thu, 21 Jul 2016 20:57:20 GMT

you can use expression on field like this date[week_min_date]

you can format de date on conditinal for value be equal your fiel

exemple field_date={"$(=date(today(),'DD/MM/YYYY'))"}

what is the format your field week_min_date?

Re: Quantity sum <= today

Fri, 22 Jul 2016 08:37:07 GMT

Hi,

Thanks for the response.

The date format is same for today and my date field.

Still it is not working.

Actually, by default, I want to show qty sum <= today in a KPI.

Thanks,

Rahul

Re: Quantity sum <= today

tresB — Fri, 22 Jul 2016 08:44:18 GMT

Possibly the date format mismatch would be causing the issue. Could you post a sample qvw?

Re: Quantity sum <= today

susovan — Fri, 22 Jul 2016 08:49:04 GMT

Hi Rahul,

You can also try this below expression,

Sum({$<[week_min_date]={">=$(=today())"},week_flag={'P'},week_Act={'Discharging'}, LocationId={250} >} QTY)

Re: Quantity sum <= today

Fri, 22 Jul 2016 09:01:59 GMT

No,its not working.

Still it is not working.

Actually, by default, I want to show qty sum <= today in a KPI.

Thanks,

Rahul

Re: Quantity sum <= today

tresB — Fri, 22 Jul 2016 09:06:19 GMT

Is your date '[week_min_date]' a date field or a text field. I see, you are trying to use date() around the date field in your set expression. Check in the list box, if the date field is left-aligned or right-aligned. If right-aligned, the following expression style should work.

=Sum({<[week_min_date]={'<=$(=Today())'}>}QTY)

If left-aligned, it's a text field, you have to correct it in the script like:

Date(Date#([week_min_date], 'format')) as [week_min_date]

Re: Quantity sum <= today

MindaugasBacius — Fri, 22 Jul 2016 09:06:57 GMT

You have forgotten "=" sign:

Sum({$<date[week_min_date]={">=$(=today())"},week_flag={'P'},week_Act={'Discharging'}, LocationId={250} >} QTY)

Re: Quantity sum <= today

Fri, 22 Jul 2016 09:24:42 GMT

Sorry, still not working.

This I have tried.

Actually, by default on a sheet, I want to show qty sum <= today in a KPI.

Thanks,

Rahul

Re: Quantity sum <= today

Fri, 22 Jul 2016 09:57:22 GMT

One thing to be noted that the today() is not appearing in brown/blue color.

Does it gives any guesses to you??

Re: Quantity sum <= today

Fri, 22 Jul 2016 09:57:51 GMT

One thing to be noted that the today() is not appearing in brown/blue color.

Does it gives any guesses to you??

Re: Quantity sum <= today

Fri, 22 Jul 2016 09:58:06 GMT

One thing to be noted that the today() is not appearing in brown/blue color.

Does it gives any guesses to you??