topic How to create a field from a field value? in QlikView

How to create a field from a field value?

rt_new_user — Wed, 24 Jul 2019 07:44:11 GMT

Hi QV users

I have a question if you can help please?

I have a field called " 'KPI_Name'.

It has several values under it eg. '1.unique_roamers', '1.session_count' etc etc. as shown below. I am hoping to create fields out of this values for eg a field called 1.unique_roamers and 1.session_count

Is it possible?

Re: How to create a field from a field value?

Miguel_Angel_Baeyens — Wed, 24 Jul 2019 11:00:54 GMT

I think a CROSSTABLE load could help you here. Take a look at

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/crosstable.htm

Re: How to create a field from a field value?

rt_new_user — Wed, 24 Jul 2019 12:15:23 GMT

Sorry from what I could understand from the article, I implemented this but didn't get the desired outcome:

Data:
LOAD

Date(Date#(PARTKEY,'YYYYMMDD'),'DD/MM/YYYY') as Date,
TECHNOLOGY,
PARAM_SET_NAME as [RIS Table Name],
BATCH_DATE,
COLUMN_HEADER as KPI_Name,
COLUMN_SUB_HEADER,
ROW_HEADER as [Country Name],
ROW_SUB_HEADER as [Network Name],
DATA_VALUE,
ITEM_STATUS;

Temp_DATA:
Crosstable (KPI_Name,DATA_VALUE)
LOAD
[1.session_count],[1.unique_roamers],
[2.roamer_distribution_%],
[2.session_success],
[3.session_fail],
[3.steering_%],
[4.session_success_%],
[GPRS_Success_rate_WO_TR],
[GSM_Success_rate_WO_TR],
[LTE_Success_rate]

FROM
[E:\Qlikview\Qlikview_Apps\_Global\1.Extract\2.QVD\DAILY_IR\HUEY\Summary_Files\I*.qvd]
(qvd);

The output I got added some undesirable fields and extra fields under KPI_Name 😞

[cid:image001.png@01D5426D.07F876D0]

Re: How to create a field from a field value?

Miguel_Angel_Baeyens — Wed, 24 Jul 2019 14:08:33 GMT

See some examples here:

https://community.qlik.com/t5/QlikView-App-Development/NoConcatenate-CrossTables/td-p/194586

https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083

https://community.qlik.com/t5/QlikView-Scripting/How-to-transpose-values-from-a-table-and-group-them-by-a-field/td-p/522055

I don't have any sample QVW to share handy, the only I uploaded years ago has a broken link.