topic SUM IF with a date in LOAD Script in QlikView

SUM IF with a date in LOAD Script

Anonymous — Tue, 19 Jul 2016 14:44:43 GMT

Hello everyone. I am having trouble getting the syntax right in my load script. Here is what I have:

SUM(IF(SO_AD_SEG_MET.w_prd_dt='2016-04-01',SO_AD_SEG_MET.metric_value)) AS test

What is wrong with this syntax, please?

Re: SUM IF with a date in LOAD Script

vishsaggi — Tue, 19 Jul 2016 14:49:02 GMT

Are you writing this aggregation as an SQL statement. Did you use Group By clause in the end ?

LOAD

SQL SELECT

col1,

col2,

SUM(IF(SO_AD_SEG_MET.w_prd_dt='2016-04-01',SO_AD_SEG_MET.metric_value)) AS test

FROM SO_AD_SEG_MET

GROUP BY Col1, Col2......

Something like this. Can you post the whole script statement you are using and the error you are getting?

Re: SUM IF with a date in LOAD Script

Mark_Little — Tue, 19 Jul 2016 14:50:19 GMT

Hi,

what is the error you are getting.

As you are doing aggregate you probably need to add a group by after your load or resident.

Mark

Re: SUM IF with a date in LOAD Script

Anonymous — Tue, 19 Jul 2016 14:51:09 GMT

I am trying to accomplish this sum-if in the load statement. Is that not possible?

Re: SUM IF with a date in LOAD Script

sunny_talwar — Tue, 19 Jul 2016 14:51:37 GMT

Syntax doesn't seem to be wrong, what is the error you are getting? Have you made sure to add the Group by statement as mentioned by vishsaggi‌ above?

Re: SUM IF with a date in LOAD Script

sunny_talwar — Tue, 19 Jul 2016 14:52:18 GMT

It is possible, what is the script for the whole table? and what error are you getting?

Re: SUM IF with a date in LOAD Script

Anonymous — Tue, 19 Jul 2016 14:52:50 GMT

what is your result?

check the dateformat of SO_AD_SEG_MET.w_prd_dt

Re: SUM IF with a date in LOAD Script

Anonymous — Tue, 19 Jul 2016 14:53:09 GMT

I did need to use aggregation (a group by). Thank you