topic Re: Addition in Set Analysis in QlikView

Addition in Set Analysis

Fri, 02 Aug 2013 12:36:49 GMT

Hi,

I have a pivot chart which contains the fields tabs hr,manager,ceo,sales and count of employees in each tab like below. Now I need to get the Toatl by adding hr.manager,ceo,sales. Could anyone help me how to write by using Set Analysis as previously I entered the vaues by using Set Analysis. But now I could not able to get the addition in Set Analysis

LIST	hr	manager	ceo	sales	Total
case	343	453	45	7
exception	565	5645	567	342
region	676	65	3345	76
crest	45	67	6	8

Thanks.

Re: Addition in Set Analysis

Fri, 02 Aug 2013 12:44:49 GMT

Hi,

I have a pivot chart which contains the fields hr,manager,ceo,sales and count of employees in each tab like below. Now I need to get the Total by adding hr.manager,ceo,sales. Could anyone help me how to write by using Set Analysis as previously I entered the vaues by using Set Analysis. But now I could not able to get the addition in Set Analysis

LIST	hr	manager	ceo	sales	Total
case	343	453	45	7
exception	565	5645	567	342
region	676	65	3345	76
crest	45	67	6	8

Thanks.

Re: Addition in Set Analysis

Fri, 02 Aug 2013 12:51:52 GMT

Thanks for your answer. I tried it but it is getting zereos in all rows. Could you let me know why it is like this.

Thanks.

Re: Addition in Set Analysis

er_mohit — Fri, 02 Aug 2013 12:57:31 GMT

try withot sum() function

column(1)+column(2)+column(3)+column(4)

Re: Addition in Set Analysis

Fri, 02 Aug 2013 13:02:17 GMT

Thanks for you answer Mohit,

Excellent , It's working.