topic Re: Ignore All filters except the condition in App Development

Ignore All filters except the condition

vsabbise — Sat, 16 Nov 2024 07:22:00 GMT

Hi,

I am trying to come up with the count of Id's with a condition. I used set analysis to specify the condition and used {1} to make the expression reflect static count without any effect on the filters but the count still changes when ever there is a change in the filters.

=count(distinct {1< OS_id=p(Si_d)>} OS_id )

Is there a way to make the above expression always reflect static count irrespective of filters selection ?

Re: Ignore All filters except the condition

sunny_talwar — Thu, 01 Nov 2018 16:07:47 GMT

Try this

=Count(DISTINCT {1<OS_id $::Si_d>} OS_id)

Re: Ignore All filters except the condition

vsabbise — Thu, 01 Nov 2018 16:11:29 GMT

Thanks. It says error in expression. Not sure what's missing

Re: Ignore All filters except the condition

sunny_talwar — Thu, 01 Nov 2018 16:16:37 GMT

My bad, I forgot the equal sign... try this

=Count(DISTINCT {1<OS_id = $::OS_id>} OS_id)

Re: Ignore All filters except the condition

vsabbise — Thu, 01 Nov 2018 17:08:24 GMT

Sorry This is not what I wanted. I need to display the count of all OS_id that have Si_Id in them without being effected by any filter. Your expression results the count only when I select a specific OS_id.

Re: Ignore All filters except the condition

sunny_talwar — Thu, 01 Nov 2018 17:10:24 GMT

What exactly do you mean when you say OS_id that have Si_Id in them? Can you share an example?

Re: Ignore All filters except the condition

vsabbise — Thu, 01 Nov 2018 17:12:42 GMT

lets say Si_id have {1,2,3,9} & OS_id have { 1,2,3,4,5,6,7}. The expression should return 3..

Re: Ignore All filters except the condition

sunny_talwar — Thu, 01 Nov 2018 17:15:41 GMT

May be try this

=Count(DISTINCT {1<OS_id = p({1} Si_d)>} OS_id)

Re: Ignore All filters except the condition

vsabbise — Thu, 01 Nov 2018 17:20:30 GMT

Perfect.This worked.

Thanks a lot. So looks like I need to put {1} to the section which I want to be masked.

Re: Ignore All filters except the condition

sunny_talwar — Thu, 01 Nov 2018 17:23:37 GMT

So looks like I need to put {1} to the section which I want to be masked.

Masked? I am not sure what that means , but essentially p() function needs to ignore selection as we well, otherwise selection will alter Si_d which will impact your final result