Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bob654321
Contributor
Contributor

Top N issue ?

Please find the attached qvw.

1) How to arrange the order of the columns in the below format without changing the data ?

(Physician Name, Physician Specialty, Physician ID, Current Position, Total Requests, % of Grand Total, Previous Quarter Position, Previous Quarter Total Requests, % Web, CD Rate, Previous CD Rate, Most Frequently Referred To Facility)

2) For the second ranked physician Lester, the previous CD rate should be 16.7% because the numerator/denominator = 1/6 but it is showing up as 66.7% in my qvw ?

Labels (2)
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

The problem with re-arranging columns is that the top N is based on the first column(1).

Also some of your expressions are referring to the column number rather than the column name.

View solution in original post

2 Replies
Lisa_P
Employee
Employee

The problem with re-arranging columns is that the top N is based on the first column(1).

Also some of your expressions are referring to the column number rather than the column name.

View solution in original post

Brett_Bleess
Support (Former)
Support (Former)

Bob, did Lisa's post help you with things?  If so, do not forget to return to your thread and use the Accept as Solution button on her post to give her credit for the help and to let the other Community Members know it did help you.  If you still need further help, please leave an update post on the thread with what you still need.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.