Creating a table view in qlik view

[akhil148265]

Hi Guys,

I am completely new to Qlik View, my requirement is to create a table (which has two columns in the raw data).

For example raw data looks like below.

Column1	Column 2
New- India	500
old -Europe	7000
era - South Africa	900

and my report should look like below in qlikview:-

	India	Europe	Southafrica
New	500
Old		7000
era			900

Could anyone suggest me how should I proceed. Thanks in advance.

Regards,

Akhil.

[sunny_talwar]

Parse out Column1 into two fields using SubField function

Table:
LOAD *,
	 SubField(Column1, '-', 1) as Column1A,
	 SubField(Column1, '-', 2) as Column1B;
LOAD * INLINE [
    Column1, Column2
    New-India, 500
    old-Europe, 7000
    era- South Africa, 900
];

and then use a pivot table to display the information

[akhil148265 · Accepted solution]

Let me try and get back to you @sunny_talwar . Thanks for your quick response.

Regards,

Akhil.

[Brett_Bleess]

Akhil, did Sunny's post help you get what you needed?  If so, do not forget to return to the thread and use the Accept as Solution button on his post to give him credit for the help and let other Community Members know it did work.  If you are still working on things, leave an update on what you still need.

Regards,
Brett