topic Re: Creating a table view in qlik view in QlikView

Creating a table view in qlik view

akhil148265 — Sat, 16 Nov 2024 01:55:18 GMT

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.

Re: Creating a table view in qlik view

sunny_talwar — Mon, 18 Nov 2019 12:42:22 GMT

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

Re: Creating a table view in qlik view

akhil148265 — Mon, 18 Nov 2019 12:48:26 GMT

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

Regards,

Akhil.

Re: Creating a table view in qlik view

Brett_Bleess — Tue, 03 Dec 2019 21:56:53 GMT

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