Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

HowTo: DISTINCT RangeCount(<Columns>) ?

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!

2 Replies
Not applicable
Author

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

Not applicable
Author

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?