Set Analysis to ignore any selection.

[parthesh]

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.

[maxgro · Accepted solution]

you can read here

https://community.qlik.com/t5/QlikView-Documents/Ignore-all-selections-except-some-specific-fields-u...

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/Se...

[parthesh]

Thanks a lot I was looking for this.

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