Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
brucemazynzolt
Contributor II
Contributor II

Straight Table Concatenation of two columns

Hi All,

I am trying to get the require column(Final Data) in the below table

I have two columns in my straight table called Data1 and Data2 so I need to concatenate and get the required column called Final Data and this should be done in design level only, not in script level.

 

Data1Data2Final Data
-APAP
-abcdef-
PackingAPAP / Packing

Packing

abcdef

abcedf

---

Any suggestions or help is highly appreciated.

Thanks,

Bruce

7 Replies
Chanty4u
Champion III
Champion III

try

=Data1&Data2

Chanty4u
Champion III
Champion III

or

Data1 &' '& Data2 as  FieldData

Digvijay_Singh
Master III
Master III

Whats the logic to calculate Final Data. The output you have shown looks like not following any pattern. May be I am missing something?

isingh30
Specialist
Specialist

What's the logic behind this requirement. It's very confusing. First result is AP & second one is null why?

Why last result is data 2 not 1?

Thank you!

brucemazynzolt
Contributor II
Contributor II
Author

Here the Data2 column data 'AP' is important to display.

Yes you are right we need to write logic to display the data as shown in the table

Thanks

isingh30
Specialist
Specialist

'important to display' is not a logical thing. You have to work on you requirement part. There has to be a criteria for everything.


Thank you!

zebhashmi
Specialist
Specialist

Your Table does not have Logic.

if you just want then togaher

yes

Data1&'/'&Data2

will work otherwise you can use if on the top of it.