topic Re: Adding two fields into one in QlikView

Adding two fields into one

NavinReddy — Mon, 15 Sep 2014 15:18:29 GMT

Dear Experts,

i have region dimension in this i have two separate fields

Asia and Japan these two fields i want to make it One filed

How can i do this

Thanks In Advance

Niranjan

Re: Adding two fields into one

ecolomer — Mon, 15 Sep 2014 15:21:23 GMT

Use this function:

'Asia' &'-'&'Japon' as XX

with fields...

Continent & '-'& Pays

Re: Adding two fields into one

MK_QSL — Mon, 15 Sep 2014 15:23:23 GMT

Can you elaborate little more what is meant by two fields into one...?

If you want to merge data where Region is Japan and Asia, consider below case...

Sales:

Load

If(Region = 'Japan','Asia', Region) as Region,

Sales

Inline

[

Region, Sales

Asia, 100

Japan, 120

India, 140

USA, 200

UK, 140

];

If(Region = 'Asia','Japan', Region) as Region,

Re: Adding two fields into one

NavinReddy — Mon, 15 Sep 2014 15:25:35 GMT

Hi Enrique,

How can i write script wise

Give me some example

Regards,
Niranjan

Re: Adding two fields into one

NavinReddy — Mon, 15 Sep 2014 15:30:26 GMT

Hi Manish,

I want to do Merge and i need to rename it also

Ex: 'Asia' &'-'&'Japon' as Asia Include Japan

Regards,
Niranjan

Re: Adding two fields into one

MK_QSL — Mon, 15 Sep 2014 15:49:17 GMT

Temp:

Load

If(Region = 'Asia' or Region = 'Japan','Asia-Japan', Region) as Region,

Sales

Inline

[

Region, Sales

Asia, 100

Japan, 120

India, 140

USA, 200

UK, 140

];

NoConcatenate

Final:

Load

Region,

SUM(Sales) as Sales

Resident Temp Group By Region;

Drop Table Temp;

Re: Adding two fields into one

NavinReddy — Mon, 15 Sep 2014 16:09:58 GMT

Hi Manish,

I tried but its not working Please find the attachment

Regards,
Niranjan

Re: Adding two fields into one

martynlloyd — Mon, 15 Sep 2014 16:37:19 GMT

Hi Niru,

You were so close, but the values of Level 3 are Text, not field names, so no [ ]

IF(([Level 3]='IM Asia ex Japan Ops' or [Level 3]='IM Japan Ops','IM Asia Includs Japan Ops',[Level 3]) as [Level 3],

Regards,

Re: Adding two fields into one

NavinReddy — Mon, 15 Sep 2014 17:49:36 GMT

Hi Martyn,

Thank you so much its working fine