Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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??
I have, and using this makes my data show up incomplete or as a singular point instead of a line