topic Show data that is not in selection in QlikView

Show data that is not in selection

Thu, 22 May 2014 12:57:19 GMT

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

Re: Show data that is not in selection

mdmukramali — Thu, 22 May 2014 13:22:23 GMT

Dear,

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

Thanks,

Mukram.

Re: Show data that is not in selection

Thu, 22 May 2014 13:34:59 GMT

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

Re: Show data that is not in selection

Thu, 22 May 2014 14:28:30 GMT

Hi Mukram

Here is some sample data.

Thanks

Pieter

Re: Re: Show data that is not in selection

Thu, 22 May 2014 14:54:48 GMT

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.

Re: Re: Show data that is not in selection

Thu, 22 May 2014 14:59:55 GMT

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

Re: Show data that is not in selection

Thu, 22 May 2014 15:06:55 GMT

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