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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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?