topic Re: Set Analysis to ignore any selection. in QlikView

Set Analysis to ignore any selection.

parthesh — Mon, 12 Jun 2023 11:45:05 GMT

Hello Experts,

I have below expression in my text object. it is showing correct result until we select anything from filter.

Date(Rangemin(Date(Date#(WIP_LAST_UPDATE_DATE,'MM-DD-YYYY hh:mm'),'mm-dd-yyyy'),
Date(Date#(REL_LAST_UPDATE_DATE,'MM-DD-YYYY hh:mm')),'mm-dd-yyyy'),'MM-DD-YYYY HH:MM')

I want to have value in my text object which should not get affected by any selection throughout the dashboard.

Thanks in advance.

Re: Set Analysis to ignore any selection.

maxgro — Mon, 12 Jun 2023 12:57:38 GMT

you can read here

https://community.qlik.com/t5/QlikView-Documents/Ignore-all-selections-except-some-specific-fields-using-Set/ta-p/1482031

or try with (add date#)

rangemin(min({1} REL_LAST_UPDATE_DATE), min({1} WIP_LAST_UPDATE_DATE))

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

Re: Set Analysis to ignore any selection.

parthesh — Mon, 12 Jun 2023 13:45:32 GMT

Thanks a lot I was looking for this.

rangemin(min({1} REL_LAST_UPDATE_DATE), min({1} WIP_LAST_UPDATE_DATE))