Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

microwin88x
Contributor II

Combining Multiple Fields

Hello,

I have a table with all the following fields:

Date (DD/MM/YYYY) / Expiration_Date (DD/MM/YYYY) / Total_1 / Expiration_Date_2 (DD/MM/YYYY) / Total_2

With this fields I need to show this table (which I've done and it's ok):

 

DateExpiration_Date_1Total_1
28/3/201819/1/2021$ 1,52
28/3/201818/1/2019$ 2,29
28/3/201818/1/2022$ 2,29
28/3/20183/4/2018$ 2,35
28/3/20182/7/2018$ 2,35
28/3/20183/10/2018$ 2,35
28/3/201831/12/2018$ 2,35
28/3/20182/4/2019$ 2,35
28/3/20181/7/2019$ 2,35
28/3/20182/10/2019$ 2,35
28/3/201830/12/2019$ 2,35
28/3/201830/3/2020$ 2,35
28/3/201830/6/2020$ 2,35
28/3/201830/9/2020$ 2,35
28/3/201830/12/2020$ 2,35
28/3/201830/3/2021$ 2,35
28/3/201830/6/2021$ 2,35
28/3/201830/9/2021$ 2,37
28/3/201810/10/2018$ 2,80
28/3/201828/5/2018$ 2,94
28/3/201828/8/2018$ 2,94
28/3/201828/11/2018$ 2,94
28/3/201828/2/2019$ 2,94
28/3/201828/5/2019$ 2,94
28/3/201828/8/2019$ 2,94
28/3/201828/11/2019$ 2,94
28/3/201827/2/2020$ 2,94
28/3/201827/5/2020$ 2,94
28/3/201827/8/2020$ 2,94
28/3/201830/11/2020$ 2,94
28/3/201825/2/2021$ 2,94
28/3/201826/5/2021$ 2,94
28/3/201826/8/2021$ 2,94
28/3/201829/11/2021$ 2,94
28/3/201823/2/2022$ 2,96
28/3/201820/1/2020$ 3,05
28/3/201816/4/2018$ 4,00
28/3/201823/5/2018$ 5,00
28/3/201825/6/2018$ 5,00
28/3/201825/7/2018$ 5,00
28/3/201826/10/2018$ 5,00
28/3/201819/7/2018$ 5,50
28/3/201817/8/2018$ 7,80
28/3/201811/5/2018$ 9,93
28/3/201823/4/2018$ 10,00
28/3/20184/6/2018$ 12,00
28/3/201827/4/2018$ 18,00
28/3/20185/9/2018$ 20,00

But now I need to add this other table to my previous table:

DateExpiration_Date_2Total_2
28/3/20183/4/2018$ 8,56
28/3/20184/4/2018$ 9,06
28/3/201811/5/2018$ 9,93

And then have the following, all in a single table:

DateExpiration_DateTotal
28/3/201819/1/2021$ 1,52
28/3/201818/1/2019$ 2,29
28/3/201818/1/2022$ 2,29
28/3/20183/4/2018$ 2,35
28/3/20182/7/2018$ 2,35
28/3/20183/10/2018$ 2,35
28/3/201831/12/2018$ 2,35
28/3/20182/4/2019$ 2,35
28/3/20181/7/2019$ 2,35
28/3/20182/10/2019$ 2,35
28/3/201830/12/2019$ 2,35
28/3/201830/3/2020$ 2,35
28/3/201830/6/2020$ 2,35
28/3/201830/9/2020$ 2,35
28/3/201830/12/2020$ 2,35
28/3/201830/3/2021$ 2,35
28/3/201830/6/2021$ 2,35
28/3/201830/9/2021$ 2,37
28/3/201810/10/2018$ 2,80
28/3/201828/5/2018$ 2,94
28/3/201828/8/2018$ 2,94
28/3/201828/11/2018$ 2,94
28/3/201828/2/2019$ 2,94
28/3/201828/5/2019$ 2,94
28/3/201828/8/2019$ 2,94
28/3/201828/11/2019$ 2,94
28/3/201827/2/2020$ 2,94
28/3/201827/5/2020$ 2,94
28/3/201827/8/2020$ 2,94
28/3/201830/11/2020$ 2,94
28/3/201825/2/2021$ 2,94
28/3/201826/5/2021$ 2,94
28/3/201826/8/2021$ 2,94
28/3/201829/11/2021$ 2,94
28/3/201823/2/2022$ 2,96
28/3/201820/1/2020$ 3,05
28/3/201816/4/2018$ 4,00
28/3/201823/5/2018$ 5,00
28/3/201825/6/2018$ 5,00
28/3/201825/7/2018$ 5,00
28/3/201826/10/2018$ 5,00
28/3/201819/7/2018$ 5,50
28/3/201817/8/2018$ 7,80
28/3/201811/5/2018$ 9,93
28/3/201823/4/2018$ 10,00
28/3/20184/6/2018$ 12,00
28/3/201827/4/2018$ 18,00
28/3/20185/9/2018$ 20,00
28/3/20183/4/2018$ 8,56
28/3/20184/4/2018$ 9,06
28/3/201811/5/2018$ 9,93

Is there any way to do that?

Thank you!!!

4 Replies
manas_bn
Contributor

Re: Combining Multiple Fields

Wouldn't a simple concatenation help with this? Or am I missing something in the question?

Table:

Load Date, Expiration_Date, Total from QVD;

concatenate (Table)

Load Date, Expiration_Date_2 as Expiration_Date,  Total_2 as Total from QVD;

singhpooja
Contributor III

Re: Combining Multiple Fields

you can concatenate or join your table to bring your data together. Please find followinh example.

Script:-

Table:

LOAD Date,Expiration_Date_1 AS Expiration_Date ,Total_1 AS Total

Inline [Date,Expiration_Date_1,Total_1

28/03/2018,19/01/2021,$1,52

28/3/2018, 18/1/2019, $ 2,29

28/3/2018, 18/1/2022, $ 2,29

28/3/2018, 3/4/2018, $ 2,35

28/3/2018, 2/7/2018, $ 2,35

28/3/2018, 3/10/2018 ,$ 2,35];

Concatenate

Load Date,Expiration_Date_2 AS Expiration_Date,Total_2 AS Total

Inline [Date,Expiration_Date_2,Total_2

28/3/2018, 3/4/2018, $ 8,56

28/3/2018 ,4/4/2018, $ 9,06

28/3/2018, 11/5/2018, $ 9,93];

UI:-Untitled.png

arvind1494
Valued Contributor

Re: Combining Multiple Fields

Table1:

Load Date,Expiration_Date_1 AS Expiration_Date ,Total_1 AS Total inline [

DateExpiration_Date_1Total_1
28/3/201819/1/2021$ 1,52
28/3/201818/1/2019$ 2,29
28/3/201818/1/2022$ 2,29
28/3/20183/4/2018$ 2,35
28/3/20182/7/2018$ 2,35
28/3/20183/10/2018$ 2,35
28/3/201831/12/2018$ 2,35
28/3/20182/4/2019$ 2,35
28/3/20181/7/2019$ 2,35
28/3/20182/10/2019$ 2,35
28/3/201830/12/2019$ 2,35
28/3/201830/3/2020$ 2,35
28/3/201830/6/2020$ 2,35
28/3/201830/9/2020$ 2,35
28/3/201830/12/2020$ 2,35
28/3/201830/3/2021$ 2,35
28/3/201830/6/2021$ 2,35
28/3/201830/9/2021$ 2,37
28/3/201810/10/2018$ 2,80
28/3/201828/5/2018$ 2,94
28/3/201828/8/2018$ 2,94
28/3/201828/11/2018$ 2,94
28/3/201828/2/2019$ 2,94
28/3/201828/5/2019$ 2,94
28/3/201828/8/2019$ 2,94
28/3/201828/11/2019$ 2,94
28/3/201827/2/2020$ 2,94
28/3/201827/5/2020$ 2,94
28/3/201827/8/2020$ 2,94
28/3/201830/11/2020$ 2,94
28/3/201825/2/2021$ 2,94
28/3/201826/5/2021$ 2,94
28/3/201826/8/2021$ 2,94
28/3/201829/11/2021$ 2,94
28/3/201823/2/2022$ 2,96
28/3/201820/1/2020$ 3,05
28/3/201816/4/2018$ 4,00
28/3/201823/5/2018$ 5,00
28/3/201825/6/2018$ 5,00
28/3/201825/7/2018$ 5,00
28/3/201826/10/2018$ 5,00
28/3/201819/7/2018$ 5,50
28/3/201817/8/2018$ 7,80
28/3/201811/5/2018$ 9,93
28/3/201823/4/2018$ 10,00
28/3/20184/6/2018$ 12,00
28/3/201827/4/2018$ 18,00
28/3/20185/9/2018$ 20,00

];

Concatenate(Table1)


Table2:

Load Date,Expiration_Date_2 AS Expiration_Date,Total_2 AS Total

inline [

DateExpiration_Date_2Total_2
28/3/20183/4/2018$ 8,56
28/3/20184/4/2018$ 9,06
28/3/201811/5/2018$ 9,93


];

manoj217
Contributor II

Re: Combining Multiple Fields

IT is a simple question just rename the fields like table 1 by using alias it will auto- concatenate else you will do force concatenate r use join you will get one table as like your requirement

Community Browser