topic Comparison of data without using if statement in set analysis in QlikView

Comparison of data without using if statement in set analysis

rohit214 — Tue, 11 Oct 2011 12:37:39 GMT

hi all

i have a problem i want to compair year with out usinfg if statemen in set analysis.

i have to field

year1 and year2...what i want ....when the year1=year2 then i want the sum of invoiced_qty.

please help me

thanks

rohit

Comparison of data without using if statement in set analysis

ToniKautto — Tue, 11 Oct 2011 12:43:55 GMT

Please provide a sample QVW, so that it is easier to see exactly what you are doing and also give suggestions. For example it is a bit unclear if your values year1 and year2 and variables or fields, and how their relation is to invoiced_qty.

Comparison of data without using if statement in set analysis

rohit214 — Tue, 11 Oct 2011 12:51:34 GMT

hey tony

thanks for ur reply.it is confidencial so i can't share with u.

i have

year1 year2

2008 2008

2009 2009

2010 2010

2011 2011

year is fields

thanks

rohit

Comparison of data without using if statement in set analysis

rohit214 — Wed, 12 Oct 2011 04:22:23 GMT

hii all

if any one knows please help me

thanks

rohit

Re: Comparison of data without using if statement in set analysis

Wed, 12 Oct 2011 05:10:57 GMT

Hi,

Please find the attached file.I hope this will help u

Thanks

Vivek