I have a little question. I have an excel file containing the data on purchase orders of three years (2016-2017-2018), I would like to create a table in Qlik Sense for each year with the orders. If, for example, a material was bought in 2016 but not in 2017, I would like to see a zero in the 2017 table close to the description of the material. Likewise if, for example, a material was bought in 2018 but not in 2016, I would like to see zero in the quantity purchased in the reference line for that material in the 2016 table.
Is there any way to do it?
I can leave a file with data as an example. As you can see the material "DEF" was purchased in 2016 and 2018, so in the table for 2017 I would like to see both the description of the material and a zero near the description of the material.
