topic Re: Sum(Sales) with Condition in QlikView

Sum(Sales) with Condition

rajkumarb — Fri, 17 Apr 2015 16:08:01 GMT

Hi Experts please Assist

I have two fields sales, Group

Group, Sales

ABC, 10

01 20

02 30

03 40

04 50

05 60

Now need to create two more fields

1 Sum(Sales) where Group = (01,02,03,04,05) Except Sales(ABC)

2 Sum(Sales) where Group = (ABC)

So the resulting Tables should look like

Group, Sales Sum1 sum2

--------------------------------------------------

total 200 10

-------------------------------------------------

ABC, 10 10

01 20 20

02 30 30

03 40 40

04 50 50

05 60 60

giakoum — Fri, 17 Apr 2015 16:10:53 GMT

in the reload script ?

if(Group <> 'ABC', Sales, 0) as SalesNoABC,

if(Group = 'ABC', Sales, 0) as SalesABC

in a chart expression?

Sum({<Group-={"ABC"}>} Sales) for SalesNoABC

Sum({<Group={"ABC"}>} Sales) for SalesABC

Anonymous — Fri, 17 Apr 2015 16:12:32 GMT

sum(if(Group<>'ABC', Sales)

sum(if(Group='ABC', Sales)

Fri, 17 Apr 2015 16:17:57 GMT

Please find the attached qvw file..

Thanks,

Shekar.

rajkumarb — Fri, 17 Apr 2015 16:24:32 GMT

Thanks for the Quick reply It Worked

rajkumarb — Fri, 17 Apr 2015 16:25:40 GMT

Thanks Maicheal