Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

hazar_sanlier
New Contributor II

Cell value about

Hi everyone,

I've a problem.Can you help me please.

I've a table

Clomn1(Policy)   Clomn2  (ID) 

XX                           111

YY                           111

ZZ                            222

MM                          222

How can we do the following table?

Clomn2(ID)   Clomn1(Policy) 

111                    XX-YY

222                    ZZ-MM

thank you so much...

1 Solution

Accepted Solutions

Re: Cell value about

Here you go


Front End

Concat([Clomn1(Policy)],'-')


In Script

LOAD Concat([Clomn1(Policy)],'-') as Col1 ,  [Clomn2  (ID)] as Col2 Group By [Clomn2  (ID)];

LOAD * Inline [

Clomn1(Policy),  Clomn2  (ID)

XX            ,              111

YY              ,            111

ZZ              ,            222

MM                ,          222

];


4 Replies

Re: Cell value about

Here you go


Front End

Concat([Clomn1(Policy)],'-')


In Script

LOAD Concat([Clomn1(Policy)],'-') as Col1 ,  [Clomn2  (ID)] as Col2 Group By [Clomn2  (ID)];

LOAD * Inline [

Clomn1(Policy),  Clomn2  (ID)

XX            ,              111

YY              ,            111

ZZ              ,            222

MM                ,          222

];


qlikview979
Valued Contributor

Re: Cell value about

Like this


T1:

LOAD * Inline [

Policy ,  ID

XX      ,111

YY       ,111

ZZ        ,222

MM        ,222

];

NoConcatenate

T2:

LOAD

Concat(Policy,'-') as Policy,

ID

Resident T1 Group by ID;

DROP Table T1;

hazar_sanlier
New Contributor II

Re: Cell value about

Thank you so much Anil

have a nice day

hazar_sanlier
New Contributor II

Re: Cell value about

Thank you so Mahesh

have a nice day

Community Browser