Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jaarroyl
Contributor III
Contributor III

Hot to get the position of a variable in base its price

Hi, I need help to get the position of a variable in base its price. I have a list of 10 business with names "X" and market prices and I want to know what is the position of my company according my price in ascending order. For example: From 10 Bussines Prices my company is the First one, that wants to say, Im the number one.

Thanks

18 Replies
vishsaggi
Champion III
Champion III

Can you share a sample app and expected output?

jaarroyl
Contributor III
Contributor III
Author

Sample.JPG

Sure, I have this graphic that remarks my company on green. As you can see I have a table at the left side with many prices that they are sorted from lowest to highest and my company is in the 4th position.

My expected output is on the square below it, obtain the number 4.

Thanks

vishsaggi
Champion III
Champion III

Can you scramble the data and upload your sample to work on please?

You can do that here if the data is sensitive....

Preparing examples for Upload - Reduction and Data Scrambling

jaarroyl
Contributor III
Contributor III
Author

Sorry, but how can I upload the data and sample?

Regards

jaarroyl
Contributor III
Contributor III
Author

vishsaggi
Champion III
Champion III

Capture.PNGCapture1.PNGI cant access dropbox.

When you click on reply you can see link on top right corner that says 'use advance editor' when you click on that, you can attach the sample there.

jaarroyl
Contributor III
Contributor III
Author

Please give me your email. I have the qvw file to sent you.

vishsaggi
Champion III
Champion III

You can upload from QV community site, did you get my screen shots above.

When you click on reply you can see that use advanced editor (1st Pic) then in the bottom right corner you can see attachment icon (pic 2). I cant open any personal accounts at my work place so neither gmail nor dropbox or any others wont work. So please upload through QV site sorry.