Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
jsobrinho
Creator
Creator

Row number pivot table as a index

 Hi guys,

I have a pivot table with 4 dimensions, and I already have the sort columns ok. Now I need to put one more dimension with the number of a row of the table. When I inserted the rowno(TOTAL) and aggregated by the four dimensions, I have the row number but sorted by my sort expression already created, but I need the row number column only show the number of rows in sequence and not change the sort in the table, it's possible?

So I need to one column with the row number in sequence without change ordination of another columns

RowNo.png

Labels (2)
3 Replies
qliksus
Specialist II
Specialist II

In the below example Rowno 1 is for  (A ,P1 ,PP2 ) now if the sorting order changes and the first row becomes (A ,P1 ,PP3 )  do you still want to maintain the Rowno (2 or 3) for this new sorting oder change  ?  

jsobrinho
Creator
Creator
Author

First of all, thank you for your answer

No, independent of the other sorting by other columns, I want to keep the first column like an index, only showing the number of rows sequentially. In your example where the first row now is (A, P1, PP3) the Rowno should be 1 because the Rowno just shows the row number.

Brett_Bleess
Support (Former)
Support (Former)

I think in order to get further responses on this one, it may be necessary to attach a sample QVW file with the data model and some data, so folks can see everything that is going on and how you are getting to where you are, as I am a little perplexed at the moment myself.  Just need enough data to be able to play with things to see if we can get things to do what you want at that point.  

The only other thing I could give you is the link to the Design Blog area, you can search around there to see if you can find something that helps, that area is basically hundreds of how-to posts, but it can be a bit tricky finding things sometimes.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

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.