topic Re: sum with condition in QlikView

sum with condition

Wed, 27 Nov 2013 10:15:08 GMT

Hello Friends, I am working on bar chart. I have one problem. In Demention I am using column A. In Expression i want sum of column B but distinct of column C. Can any one help me in this? Thank you. Dipak

Re: sum with condition

salto — Wed, 27 Nov 2013 10:31:12 GMT

Hi Dipak,

I do not understand what do you want to sum on column C. Can you provide more details? Thank you!

Re: sum with condition

Wed, 27 Nov 2013 10:42:20 GMT

Hello, Thanks for reply. Actually I want sum of columns B (salary). But i want this sum by distinct of column C (Employee ID - repeatative in table). I can't add this ColumnsC in dimention because i am already using column A in dimention. I hope this will help you. Thanks

Re: sum with condition

salto — Wed, 27 Nov 2013 10:48:23 GMT

Hi again Dipak,

can ypu please upload an example of what you have and what you want to achieve? An image or Excel chart would be enough.

Thanks.

Re: sum with condition

Wed, 27 Nov 2013 11:01:29 GMT

Hi,

can you please tell us what value you have in columnA?

Otherwise if i understand correctly so try this in load script:

Temp:

Load

From Table;

Final:

Load

columnA,

columnC,

Sum(columnB) as TotalSum

Resident Temp

Group By ColumnA, ColumnC;

Then you can use TotalSum field in your expression with columnA but the result will show in chart according to dimension field only.

Hope this helps you.

Thanks,

Ashutosh