topic Re: HowTo: DISTINCT RangeCount(<Columns>) ? in QlikView

HowTo: DISTINCT RangeCount() ?

Mon, 14 Jan 2013 13:44:05 GMT

Hi everyone,

new day, new question - a quite simple one this time.

I need to count the unique values within a ROW. Currently I'm using RangeCount(<Column1>, <Column2>, <etc.>) in my load script and use this later on as a field in a diagram. I would need it to count only distinct values [RangeCount(DISTINCT <Column1>, <Column2>, <etc.>)]. How can I achieve this?

Thanks for your advice in advance again!

Re: HowTo: DISTINCT RangeCount() ?

Mon, 14 Jan 2013 13:57:34 GMT

Could do a cross table load in back end and a count distinct?

Re: HowTo: DISTINCT RangeCount() ?

Mon, 14 Jan 2013 14:02:10 GMT

Yes could help but I feel like due to ressource restrictions afterwards not helpful to my problem.

EDIT: Since it only works on 2 arguments its to less for my purpose. No way to count directly within rows? Or a way to count distinct values of a row within a table diagram?