topic Re: Rowno change sort in QlikView

Rowno change sort

Mon, 28 Apr 2014 15:21:57 GMT

Hi all!

Who can help me?

I want to create a table with 3 values in it. a code like "A23.30" a text that explains the code and a count() that counts the amount of identic codes in the table.

In the table i only want the top 20 most used codes.

So i want something like this:

Code	Text	Count()
A23.30	explanation	150
Q15.51	explanation2	95
J61.81	explanation3	55
etc	etc	etc

This is easy. My problem starts when i want to add a row number in front of the code. So i want an extra column to the left of the code column with the numberst 1 -> 20. I know RowNo() can do this. But when i add RowNo() to my expressions i can't sort count() anymore. I tried to push count() on top of the piority list in the sort tab. But when it was on top it didn't work ether.

Can somebody help me with this? how can i get a row number without lossing the sort() option on Count?

Thanks in advance to all that are willing to help!!!

Re: Rowno change sort

alexandros17 — Mon, 28 Apr 2014 15:26:24 GMT

Can you post your document?

Re: Rowno change sort

Mon, 28 Apr 2014 15:28:24 GMT

sorry it has clasified data in it. I'm not allowed to share the data in the document.

What did you want to know?

Re: Rowno change sort

alexandros17 — Mon, 28 Apr 2014 15:29:45 GMT

You can use scramble instruction ...

Re: Rowno change sort

Mon, 28 Apr 2014 15:35:59 GMT

I can show you this. There i have the 4 things i want in my table. It has to sort on Count. O and i'm sorry but I installed the Dutch version and haven't got the time to uninstall and instal the English version.