topic Re: Qlikview Set Analysis Ignore selection not working in QlikView

Qlikview Set Analysis Ignore selection not working

Anonymous — Mon, 18 Dec 2017 20:21:08 GMT

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!

Re: Qlikview Set Analysis Ignore selection not working

sunny_talwar — Mon, 18 Dec 2017 20:25:12 GMT

Are these two guys static or expression?

vETEStartDateInput

and

vETEEndDateInput

If these two contain expression, may be you need to ignore the field within them

Re: Qlikview Set Analysis Ignore selection not working

Anonymous — Mon, 18 Dec 2017 20:50:53 GMT

I created these Date variables and using in Calendar.

For 'vETEStartDateInput' and 'vETEEndDateInput' using :

Min Value:=min({1}%DIM_DATE_KEY)

Max Value:= =max({1}%DIM_DATE_KEY)

Re: Qlikview Set Analysis Ignore selection not working

Anonymous — Mon, 18 Dec 2017 21:59:52 GMT

Also, I am using alternate state here.

For Calendar Date field, For other two Date Range Calendar and in straight table as well.

So Do I need to specify alternate state in the expression while ignoring the Date selection for %DIM_DATE_KEY.

Re: Qlikview Set Analysis Ignore selection not working

Anonymous — Mon, 18 Dec 2017 23:19:16 GMT

Hi Sunny,

Please find the attached image.

For first two expressions I want to use "Date" calendar and for last expression I want to use 'From ETE Date' and 'To ETE Date' date range by ignoring the 'Date' selection.

Re: Qlikview Set Analysis Ignore selection not working

sunny_talwar — Mon, 18 Dec 2017 23:43:17 GMT

Would you be able to share a sample to look at this?

Re: Qlikview Set Analysis Ignore selection not working

Anonymous — Tue, 19 Dec 2017 00:39:59 GMT

It seems when I add 'ALLIANCE_NAME=P({<ALLIANCE_NAME>})' in the expression, at that time it doesn't work.

But without this it ignores the Date selection.

=sum( {< %DIM_DATE_KEY= ,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)

Re: Qlikview Set Analysis Ignore selection not working

sunny_talwar — Tue, 19 Dec 2017 01:56:29 GMT

May be try this

=Sum({<%DIM_DATE_KEY, IN_OUT_TRANSFER = {'INBOUND'}, SALES_REP_CENTRAL_IDENTITY, ALLIANCE_NAME = P({<%DIM_DATE_KEY>}ALLIANCE_NAME), %DIM_DATE_KEY = {">=$(vETEStartDateInput)<=$(vETEEndDateInput)"}>} CALL_COUNT)

or this

=Sum({<%DIM_DATE_KEY, IN_OUT_TRANSFER = {'INBOUND'}, SALES_REP_CENTRAL_IDENTITY, ALLIANCE_NAME = $::ALLIANCE_NAME, %DIM_DATE_KEY = {">=$(vETEStartDateInput)<=$(vETEEndDateInput)"}>} CALL_COUNT)

Re: Qlikview Set Analysis Ignore selection not working

Anonymous — Tue, 19 Dec 2017 20:17:51 GMT

Thanks a lot Sunny, It's working as expected.

Thank you so much

Re: Qlikview Set Analysis Ignore selection not working

sunny_talwar — Tue, 19 Dec 2017 20:26:45 GMT

Which of the two worked for you?

Re: Qlikview Set Analysis Ignore selection not working

Anonymous — Tue, 19 Dec 2017 20:37:02 GMT

Both expressions are working. Thank you..