Expression for calculating sell through

sakshikaul — Wed, 25 Nov 2020 16:16:04 GMT

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%')

topic Expression for calculating sell through in QlikView

Expression for calculating sell through