Show data that is not in selection

[#1]

Hi Everyone

I am new to Qlikview and need some help.

I have a selection of data based on a SellBy_Date. I filter the data using a calendar object. I use two variables namely vStartSell and vEndSell. This gives me data that is going to expire in a certain time frame. I want to now show in the same chart the weight of the items that have been sold 4 weeks back. Thus it must be 4 weeks(28 days) back from vStartSell. The weight of the items sold must be calculated.

Can anyone maybe help?

Thanks

Pieter

[mdmukramali]

Dear,

Can you share some sample data. so that we can help you.

Thanks,

Mukram.

[#3]

you can try something like sum({SellBy_Date = {">=($(vStartSell)-28)<=$(vStartSell)"}} Sales)

[#4]

Hi Mukram

Here is some sample data.

Thanks

Pieter

[#5]

Hi Peter

I have attached a document that may be your solution.

I used a third variable, vPreviousFourWeeks = vStartSell - 28.

Also, I have provided 3 tables: Current Month, Previous Month, and another that shows both in the same table.

[#6]

Hi Jacob

I have the personal edition of Qlikview... I cannot view the file you sent me.

Thanks for the help, I appreciate it.

Pieter

[#7]

Oh okay.

These expressions work for me:

sum({<SellBy_Date = {">=($(vStartSell) - 28)<=$(vStartSell)"}>}Weight)

^^^Calculates weight for previous 28 days

sum({$<SellBy_Date = {">=$(vStartSell)<=$(vEndSell)"}>}Weight)

^^^Calculates weight for the interval from vStartSell to vEndSell