Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlikview Set Analysis Ignore selection not working

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!




10 Replies
Anonymous
Not applicable
Author

Both expressions are working. Thank you..