topic Re: Chart expression with field from another table in QlikView

Chart expression with field from another table

denisb — Fri, 15 Nov 2024 23:38:53 GMT

Hi,

I have some tables like the blue tables in this picture and I want a table chart like the yellow one.

Stores is my dimension table and Orders is my fact table.

To get the total Amount for each store is easy. Just take sum(Amount).

But I also want to know the sum(Amount) before pp_date and after pp_date for each store. So need, somehow, to pick the right pp_date into my expressions.

This does not work -> Sum({$<Datum={"<pp_date"}>}Amount)

You know what I mean? 🙂 Maybe someone has an idea.

Thanks

Re: Chart expression with field from another table

chrismarlow — Wed, 11 Nov 2020 16:24:52 GMT

Hi,

I think you can just use IF statement to do this, like;

Cheers,

Chris.

Re: Chart expression with field from another table

denisb — Fri, 13 Nov 2020 07:42:49 GMT

Thanks.

Yes, of course this works. I tried it before, but it didn´t work. Know I found a mistake in my datamodel/dataset.

I had some stores with the same data (in my stores table) four times. So my expression made the correct SUM of amount, but four times.

Crazy 😄