How to calculate varience%

[rohit214]

Hi All ,

i have to calculate the varience with some condotion or logic,

1)if Q8-Q1 varience is -ve then i have to convert into positive value,

2) if Q8-Q1 varience is +ve or zero then convert it zero.

as shown in below.

ID	Customer Name	Dealer Name	Dealer Code	Region	Q1 rating	Q8 Rating
1	C1	D1	A1	XYZ	10	9
2	C2	D1	A1	XYZ	9	10
3	C3	D1	A1	XYZ	8	10
4	C4	D1	A1	XYZ	10	8
5	C5	D1	A1	XYZ	9	9

now My requirement is bsaed on below logic

Varience%=total(vaience)/total(Q8 rating) i.e 3/46=6.13%

and required format of able is

ID	Customer Name	Dealer Name	Dealer Code	Region	Q1 rating	Q8 Rating	Q8-Q1	Varience	Varience%
1	C1	D1	A1	XYZ	10	9	-1	1	6.13%
2	C2	D1	A1	XYZ	9	10	1	0	6.13%
3	C3	D1	A1	XYZ	8	10	2	0	6.13%
4	C4	D1	A1	XYZ	10	8	-2	2	6.13%
5	C5	D1	A1	XYZ	9	9	0	0	6.13%

thanks &regards

rohit

[CELAMBARASAN]

Hi,

     Did you tried like this?.

     Sum(TOTAL aggr(

If(sum({<[CS Survey]={'SBC'},QuestionNo={'Q8'},VIN_No_SBC=p(VIN_No_PSFU)>} rat)-

sum({<[CS Survey]={'Post Service Follow Up - 2012'},[Question No]={'Q1'},VIN_No_PSFU=p(VIN_No_SBC)>}ans)<0,

Fabs(sum({<[CS Survey]={'SBC'},QuestionNo={'Q8'},VIN_No_SBC=p(VIN_No_PSFU)>} rat)-

sum({<[CS Survey]={'Post Service Follow Up - 2012'},[Question No]={'Q1'},VIN_No_PSFU=p(VIN_No_SBC)>}ans)),0),ID

))/Sum(TOTAL {<[CS Survey]={'SBC'},QuestionNo={'Q8'},VIN_No_SBC=p(VIN_No_PSFU)>} rat)

Celambarasan

[rohit214]

hi

I tried but it shows Q1-Q8/Q8 rating  for all customer which is wrong answer

but i want varience/Q8 rating in that example values should be 3/46

thanks &regards

rohit

[rohit214]

Hi all please suggest me.

how to get sum ( total varience)/sum(Total Q8 Rating)

for reference please take alook in tables

thanks & regards

rohit

[#5]

Hi Rohit....
I am looking for my better future in IT field.
I hv 6 months experience in QlikView with good knowledge of Server Administration, except (Set Analysis and macros).....

If any job related to Qlikview is in your knowledge , Pllzzzz inform me on my id

Gaurav99choudhary@gmail.com

Thank you
Gaurav Choudhary(India)

[rohit214]

hi gaurav,

send me your detail in rht214@hmail.com

if i can do anything for you that will be my pleasure

thanks& regards

rohit