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