topic Re: requirement for sum in QlikView

requirement for sum

kishorj1982 — Thu, 09 Nov 2017 04:49:17 GMT

hi all,

I have requirement as per below,

I have values from Jun to december.

Value of jun is base

July values is= Value of June+ Value of July.

august values== Value of June+ Value of august.

september values= Value of June+ Value of september.

Can you please suggest how to achieve this.

Thanks

Re: requirement for sum

Anil_Babu_Samineni — Thu, 09 Nov 2017 04:57:54 GMT

When we talk related base is june, You could try

Sum({<Month = {'Jun'}>}Sales)+Sum(Sales)

Re: requirement for sum

techvarun — Thu, 09 Nov 2017 05:15:22 GMT

Check the attached app

Re: requirement for sum

kishorj1982 — Thu, 09 Nov 2017 05:16:01 GMT

Thanks Anil,

Can you please suggest how to achieve this in backend.

thanks

Re: requirement for sum

techvarun — Thu, 09 Nov 2017 05:21:40 GMT

Use below script if you want to achieve this in backend

TEST:
LOAD * INLINE [
    Month, Sales
    Jan, 10
    Feb, 20
    Mar, 30
    Apr, 40
    May, 50
    Jun, 60
    Jul, 70
    Aug, 80
    Sep, 90
    Oct, 100
    Nov, 110
    Dec, 120
];


Join Load Sales as BasePrice Resident TEST Where Month ='Jun';


Load*, If(Month = 'Jun',Sales,Sales+BasePrice) as FinalPrice Resident TEST;


DROP TABLE TEST;

Re: requirement for sum

Anil_Babu_Samineni — Thu, 09 Nov 2017 05:21:48 GMT

Perhaps this?

File:

Load Month,

Sales

From Table;

Final:

NoConcatenate

Load Month, Sum(Sales) as Sales Resident File Where Match(Month, 'Jun') Group by Month Order By Month Desc;

Left Join (Final)

Load Month, Sum(Sales) as Sales Resident File Group By Month;

Drop Table File;

Re: requirement for sum

kishorj1982 — Thu, 07 Dec 2017 08:43:53 GMT

can u plz suggest how to achieve this by using if else condition in expression

Re: requirement for sum

Anil_Babu_Samineni — Thu, 07 Dec 2017 08:58:18 GMT

Are you playing in community?? Not sure, What requirement you have. I am sorry