Expression for calculating sell through

[sakshikaul]

Hi

I have a following table maintained in a qlikview

season code    event   start_date      end_date

summer               A             14-6-2018     25-6-2018

winter                   B              26-06-2018      27-6-2018

autumn                  C        28-06-2018      29-6-2018

spring                    D  29-06-2018      30-6-2018

I want in the following chart sell through should be calculated before the( start date to end date ) and also i want to calculate sell through from 25-6-2018 till date in the same chart. how can we implement this ?

calculated before the( start date to end date )

=num(

(sum( {<  Sold_Date = {"<=$(start Date)"},[Season Code] = {$(Master_CurrentSeason)} >} quantity_sold)- sum( {< Sold_Date = {"<=$(start Date)"}, [Season Code] = {$(Master_CurrentSeason)} >} quantity_returns))

/

sum( {$<[Season Code] = {$(Master_CurrentSeason)} >} quantity_received)

,

'#,##0%')

calculated before the( start date to end date )

=num(

(sum( {<  Sold_Date = {">=$(End Date)"},[Season Code] = {$(Master_CurrentSeason)} >} quantity_sold)- sum( {< Sold_Date = {">=$(sEnd Date)"}, [Season Code] = {$(Master_CurrentSeason)} >} quantity_returns))

/

sum( {$<[Season Code] = {$(Master_CurrentSeason)} >} quantity_received)

,

'#,##0%')