Line Chart

[Ishilad]

Hi, I have two tables concatenated in the Data Manager. One table is 2018 data and the other is 2019 data. I want to make a line chart that compares the same field but has one line for 2018 and another for 2019. I have tried a number of formulas and functions and am looking for suggestions.

[dplr-rn]

do you have a year field?
If so add that as a dimension (or use 2 expressions with 1 for 2018 and other for 2019 using set analysis)

[Vegar]

Have you tried this for 2019
SUM({<YearField={2019}>} valueField)

And this for 2018
SUM({<YearField={2018}>} valueField)

[cokiston]

Apologies if I am using your post for my question, is just that I couldn't find how to open a discussion in this page.

I need some help in QlikSense for the below scenario:

Column A	Column B	Column C	Desired Column:
123456789	RT	12/13/2019	11/10/2018
123456789	GF	11/10/2018	12/13/2019
987654321	RT	1/4/2019	8/3/2017
987654321	GF	8/3/2017	1/4/2019

Column A contains an identifier that generates a duplicate row if an RT and GF Date exist, if only one thse exist then the Qlik sense table will show only 1 row, what I need is a formula for a column that will show the GF Date in the RT row and vice versa. is that possible??

[Ishilad]

I have, and using this makes my data show up incomplete or as a singular point instead of a line