topic Re: comparison issue in QlikView

comparison issue

Thu, 09 Jun 2016 16:25:24 GMT

hi all,

i have products say bost,horlicks,rose milk with prices respectively.

when i pull product as dimension and

expression1:

sum(price)

expression2:

sum(price)*10

expression3:

if((sum(pricek)=sum(pricek1)),'Y','N')

the result of expression3 displays 'Y' .

why is it happening this way; actually it should display 'N' right?

PFA if needed clarification.

hic‌

Re: comparison issue

sunny_talwar — Thu, 09 Jun 2016 16:30:04 GMT

Try this instead:

If(pricek = pricek1, 'Y', 'N')

Re: comparison issue

sunny_talwar — Thu, 09 Jun 2016 16:31:10 GMT

Sum(pricek) was giving 0 and so was Sum(pricek1) and that is why the equality was holding true:

Re: comparison issue

Thu, 09 Jun 2016 16:32:38 GMT

yea, what can be the reason behind it?

Re: comparison issue

sunny_talwar — Thu, 09 Jun 2016 16:35:53 GMT

I think the reason is related to the use of aggregation over the column label (or column() function). AFAIK, you cannot use aggregation functions such as Sum, Avg, Count, etc... over the column labels.

Re: comparison issue

Thu, 09 Jun 2016 16:48:30 GMT

Even if i use fields name like:

if((sum(price)=sum(price)),'Y','N')

also it shows 'Y ---> which wrong

i am thinking what can be the exact reason behind this

Re: comparison issue

sunny_talwar — Thu, 09 Jun 2016 17:01:11 GMT

Why is Sum(price) = Sum(price) giving you Y wrong? They are the exact same thing and should equal.

Have you tried this?

If(Sum(price) = Sum(price) * 10, 'Y', 'N')

Re: comparison issue

Thu, 09 Jun 2016 17:08:48 GMT

ho its my mistake.thank you