Zero values in rows

valnod_90 — Thu, 20 Dec 2018 08:34:01 GMT

Hi guys,

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.

Thank you!

Re: Zero values in rows

tush — Thu, 20 Dec 2018 10:00:01 GMT

Hi,

I think you can achieve it by using pivot table..

Thanks

Tushar

topic Re: Zero values in rows in App Development

Zero values in rows

Re: Zero values in rows