Hi,
I have one query regarding Set analysis. I am using Date variable in Qlikview expression.
=sum( {< IN_OUT_TRANSFER = {'INBOUND'},SALES_REP_CENTRAL_IDENTITY= , ALLIANCE_NAME=P({<ALLIANCE_NAME>}), %DIM_DATE_KEY= P({1< %DIM_DATE_KEY={">=$(vETEStartDateInput)<=$(vETEEndDateInput)"} >} %DIM_DATE_KEY)>}CALL_COUNT)
'vETEStartDateInput' and 'vETEStartDateInput' these two variable I created to get the data based on selected Date Range. But at the same time I have Date Calendar and I dont want to affect the Calendar Date selection on my Date range.
I tried to ignore '%DIM_DATE_KEY' selection in set analysis. I modified my expression as below:
=sum( {< IN_OUT_TRANSFER = {'INBOUND'},SALES_REP_CENTRAL_IDENTITY= , %DIM_DATE_KEY=, ALLIANCE_NAME=P({<ALLIANCE_NAME>}), %DIM_DATE_KEY= P({1< %DIM_DATE_KEY={">=$(vETEStartDateInput)<=$(vETEEndDateInput)"} >} %DIM_DATE_KEY)>}CALL_COUNT)
but its not working. Can anyone please help me.
Thanks!
