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: 
Anonymous
Not applicable

How to separate the column having multiple data types in qlikview

Hi,

I am getting a column from the database which has got some text(description) and some telephone numbers like one starts with +44.... and some numbers starts with 07......

How can I get only +44 numbers into the chart which is my requirement.

Any help is much appreiciated.

regards,

Vamsi,

13 Replies
sunny_talwar

May be using a set analysis like this:

Sum({<[Telephone Number] = {'+44*'}>}Measure)

Anonymous
Not applicable
Author

Hi sunny,

What is this measure?

I dont understand as i am new to set analysis.

sunny_talwar

Measure is a placeholder for your actual field which you are aggregating. Since you have not shared where and how you are trying to do this, I just gave you a very generic expression.... So if you expression is Sum(Sales), add the set analysis part to make it this:

Sum({<[Telephone Number] = {'+44*'}>} Sales)

girirajsinh
Creator III
Creator III

Sum({< dimension = {"+44*"}>} Fact_measure)

Anonymous
Not applicable
Author

Just a minute, i will try to share that.

Anonymous
Not applicable
Author

endpoint.png

sunny_talwar

Where is your chart my friend? What is the expression your planned to use for your chart?

Anonymous
Not applicable
Author

Yes , the requirement i have is the Table should display the telephone numbers that starts with +44 if the user select message type as 'shortmessageendpoint ' for various 'org_name' .

You can see the 'Messageend point' list box has telephone numbers and some text

hope it makes sense.

Anonymous
Not applicable
Author

apologise. its a  straight table. Here you go..I need to display only those +44 numbers in the message endpoint s column in the straight table.endpoint.png