Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
stefanie_a
Contributor III
Contributor III

Formatting of import data

Hi,

I'm relatively new to QlikView and need your help.

My problem is best explained by an example (see file below).

I need to format data so that values from one column can be selected as different dimensions.

Unfortunataly in my raw data the dimensions "Leistung" and "Fall" are displayed in the same column.

"Leistung" always begins with the letter "J".

"Fall" always has 7 numbers. 

How can these two parameters be shown as two different dimensions without formatting manually in Excel? 

 

Thank you in advance!

 

Best regards,

Stefanie

 

Labels (2)
10 Replies
James12
Contributor
Contributor

Even i was looking for the same script.  myaccessflorida