topic Re: Month in QlikView

Month

bharatkishore — Tue, 20 Feb 2018 06:18:37 GMT

Hi All,

I am having Year field, MonthYear field, Sales org and Cat fields.

Now i have calculated one field called Adjcons.

Now i need to show value 0 where ever the month is jan and rest of logic should be same.

Attached qvw for reference. Please let me know if you need anything more.

Thanks,

Bharat

Re: Month

tresB — Tue, 20 Feb 2018 06:23:37 GMT

This?

=If( num(right(Calendar_Month_Code,2))=1,0,Sum(ADJ_CONS_YTD_1))

Re: Month

bharatkishore — Tue, 20 Feb 2018 06:33:25 GMT

Can you please share the qvw.. bec in left join i am getting an error..

Re: Month

tresB — Tue, 20 Feb 2018 06:39:31 GMT

Use the above expression in your chart.

Re: Month

bharatkishore — Tue, 20 Feb 2018 06:43:50 GMT

thank you for your reply. . But I need to do this back end because I needed that field to be converted into qvd

Re: Month

tresB — Tue, 20 Feb 2018 06:55:13 GMT

Few things need to be corrected. Try like:

left join(T6)

LOAD

If(num(Month(Calendar_Month_Code))=1,0,YTD_IB) AS ADJ_CONS_YTD_1

; // Preceding load

LOAD

Sales_Organization,

Cat,

Country,

AddMonths(Date#(Calendar_Month_Code,'YYYYMM'), 1) as Calendar_Month_Code,

YTD_IB

Resident T6 ;

Re: Month

bharatkishore — Tue, 20 Feb 2018 07:00:05 GMT

I have tried but i am getting as 0.

Your expression is working fine =If( num(right(Calendar_Month_Code,2))=1,0,Sum(ADJ_CONS_YTD_1)) and this is exactly giving me same output what i needed.

But i need to apply same logic in script and create a field.

Can you please help me on this.

Re: Month

tresB — Tue, 20 Feb 2018 07:03:24 GMT

What exactly have you got using the script I suggested? Could you post that file?

Re: Month

bharatkishore — Tue, 20 Feb 2018 07:06:18 GMT

Please find attached.

Re: Month

tresB — Tue, 20 Feb 2018 07:32:34 GMT

What if you try simply (without join):

T6:

LOAD Sales_Organization,

Cat,

Country,

Calendar_Month_Code,

Calendar_Year_Code,

Sum(ADJ_CONS_YTD) as ADJ_CONS_YTD,

sum(If(num(Month(Date#(Calendar_Month_Code,'YYYYMM')))=1,0,ADJ_CONS_YTD)) as ADJ_CONS_YTD1

FROM

C:\GCS\Development\RR\5_QVD\QV_intermediate_temp10.qvd

(qvd) group by Sales_Organization,Cat,Country, Calendar_Month_Code, Calendar_Year_Code ;

Re: Month

bharatkishore — Tue, 20 Feb 2018 08:24:48 GMT

I just tried by creating a qvd and added that field. Thanks a lot Tresesco.