topic Re: EXPRESSION ISSUE in QlikView

EXPRESSION ISSUE

Wed, 28 Oct 2015 17:23:21 GMT

WHy are these two giving me different results?? 1st one seems correct , but I expect both to give me the same outcome.

(Count({<NEW_24Mths_FLAG={'1'},Year={$(=Max(Year)-1)}>} distinct [Claim No])

Count({<NEW_24Mths_FLAG={'1'},Year={$(=Max(Year)-2)}>} distinct [Claim No])

Count({<NEW_24Mths_FLAG={'1'},Year={$(=Max(Year)-3)}>} distinct [Claim No])) /3

//******SECOND EXPRESSION*****************************************

(Count({<NEW_24Mths_FLAG={'1'},Year={$(=Max(Year)-1),$(=Max(Year)-2),$(=Max(Year)-3)}>} distinct [Claim No]) /3

jduarte12 — Wed, 28 Oct 2015 17:42:18 GMT

Hello,

I am not totally sure, but I think the difference between the expressions is the following:

Expression 1 counts distinct [Claim No] for each one of the 3 years, sums the results and you get the average in the end;

Expression 2 counts distinct [Claim No] over the set of the 3 years, meaning that it will count distinct [Claim No] present in all the years.

Regards,

Wed, 28 Oct 2015 17:50:55 GMT

I dont think so, cuz I used the same two expressions with a different flag and they both give me the same results

Wed, 28 Oct 2015 17:55:14 GMT

Hi,

I think this is because u are using Distinct.

In Expression 1 : It is counting separately but

in Expression 2 : It is counting all at once, so the distinct values will be different from expression 1.

If you remove distinct from both the expressions, it should give you the same result.

Thanks,

Faredun

Clever_Anjos — Wed, 28 Oct 2015 18:23:32 GMT

They´re not supposed to return same value.

Suppose you have [Claim No] = 0001 into Year-1, Year -2 and Year-3,

If you use first expression, that Claim No would be counted 3 times, and if you use the second expression it would be counted only once