topic Re: Mode and Only in QlikView

Mode and Only

Nagaraju_KCS — Wed, 27 Feb 2013 15:51:25 GMT

Hi All

Difference between Mode and Only

T1:

load * Inline [

ID, Age

123, 12

123, 28

145, 30

165, 15

165, 17

165, 15

165, 12

165, 18

];

T2:

load ID, mode(Age) as AgeMode, only(Age) as AgeOnly

Resident T1 Group by ID;

T2 table Returns

ID, AgeMode, AgeOnly

123,-,-

145,30,30

165,15,-

but i didn't understand..

please explain it..

Re: Mode and Only

rwunderlich — Wed, 27 Feb 2013 16:24:13 GMT

They are quite two different functions. Mode() returns the most common value in the group. Only() returns a value if there is only one value in the group, otherwise it returns null.

-Rob

Re: Mode and Only

Nagaraju_KCS — Thu, 28 Feb 2013 04:09:56 GMT

Thanks Rob...

Its very Helpful answer.................