topic Re: Restrict showing data when other data are not available in QlikView

Restrict showing data when other data are not available

retko1985 — Tue, 09 Jan 2018 13:09:13 GMT

Hello,

I have a situation when we receive one file and it is planned for the future, so numbers are for the whole month. But now in the calculations these numbers are appearing, and I want to restrict this.

My calculation is very simple, like this:

=sum(Sales_Amount)-

sum(Discount_Amount)

Sales are coming for the previous day, but discounts are for whole month. (they are not discounts, it just an example).

Now my bar chart is rising till today, and falling for the rest of the month, because I am substracting 0 - discount.

I know I might use if (sum(Sales_Amount) <> 0 ... But is this the correct solution?

Should I use some set analysis or something?

And How.

Thank you.

Re: Restrict showing data when other data are not available

tresB — Tue, 09 Jan 2018 13:14:49 GMT

You could probably use set analysis like:

=sum({<Date={'<=$(=Today())'}>} Sales_Amount)-

sum({<Date={'<=$(=Today())'}>} Discount_Amount)

Re: Restrict showing data when other data are not available

Anil_Babu_Samineni — Tue, 09 Jan 2018 13:15:36 GMT

Can we talk related more about Dataset?

Re: Restrict showing data when other data are not available

sunny_talwar — Tue, 09 Jan 2018 13:16:42 GMT

The if statement should be fine too... but you can try this

=Sum(Sales_Amount) - Sum({<Date = {"=Sum(Sales_Amount) <> 0"}>}Discount_Amount)

or this

=Sum(Sales_Amount) - Sum({<Sales_Amount = {"*"}>}Discount_Amount)

Re: Restrict showing data when other data are not available

retko1985 — Tue, 09 Jan 2018 13:26:32 GMT

1 expression gives Exceeded memory allocation.

2 is doing nothing.

Thank you.

Re: Restrict showing data when other data are not available

retko1985 — Tue, 09 Jan 2018 13:29:29 GMT

With this solution all my bars dissapear, the week from the beginning of the Year.

Thank you.

Re: Restrict showing data when other data are not available

sunny_talwar — Tue, 09 Jan 2018 13:31:01 GMT

Do you have a Date field? I mean what is your chart dimension/s?

Re: Restrict showing data when other data are not available

retko1985 — Tue, 09 Jan 2018 14:08:17 GMT

Ok, this helps. I am using working day. So after I put this, it seem correct.

Thanks.