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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Extracting particular set of values

hi

i am trying to create a call center dashboard. and i have to to display the abundant rate.. in my data set as i shown below i need to extract the numbers that i have marked from yellow. is there any possibility of doing this ..??

thanks in advance your help is greatly appreciated.

Untitled.png

8 Replies
simenkg
Specialist
Specialist

Load Number from File.xls [...]

where len(trim(Number)) = 4;

This will work if the only thing that identifies them are that they are 4 charachters long.

its_anandrjs
Champion III
Champion III

Hi,

Few questions

1. This are few numbers or there is large list

2. It is of same length in character like 4 or 5

If it is few then try to this in the load script with where exists or the Mapping table.

If possible provide the sample data

Regards

Anand

Not applicable
Author

i have another 10 digit number that i need to extract but the first 5 digit of this number (07102) would be the same what can i do to this??

simenkg
Specialist
Specialist

Load Number from File.xls [...]

where len(trim(Number)) = 4 or (left(trim(Number),5) = '07102' and len(trim(Number))=9);

Not applicable
Author

hi Anand

1) yes i have shown few from a very large list.. but most of the time same number repeats..

2) this displays a 4 digit number or a 9 digit number.

from this large list i need to extract the 4 digit numbers and a number that starts with 07102 from the whole list.

Not applicable
Author

You can try the following

WHERE

     LEN([FIELD]) = 4 or WILDMATCH([FIELD],'07102*') >= 1

puttemans
Specialist
Specialist

Or this

WHERE

     LEN(field)=4 or left(field,5)=07102

its_anandrjs
Champion III
Champion III

Hi,

Then try to load data in load script this way

Load

*

From Location

Where  Left( [abundant rate], 5 ) = '07102' And Len( [abundant rate] ) = 9 or Len( [abundant rate] ) = 4;


Regards

Anand