topic Re: Alternate States ( Only inherited state data should be seen in newly created State) in App Development

Alternate States ( Only inherited state data should be seen in newly created State)

nitin_01 — Sat, 16 Nov 2024 19:01:10 GMT

Dear Experts,

There are two straight table. Inherited and MyState. Both the table should show results on some common filters. Lets say any Year is selected, then this selection should be applied in both the table for selected value in Year field. And data in MyState table should contain only data present in Inherited State after the selection done in Year field. And how can i show the difference of these two total value's with different state in KPI.

@sunny_talwar @Gysbert_Wassenaar Would great for asap response.

Regards,

Nitin.

Re: Alternate States ( Only inherited state data should be seen in newly created State)

sunny_talwar — Mon, 02 Mar 2020 13:15:54 GMT

Not sure I understand what you have? You have certain filters which impact the individual table and then few filters in inherited state which impact both states? May be this

Sum(Measure) - Sum({MyState<Year = $::Year>} Measure)

Here we are assuming that the KPI object is in inherited state. Sum(Measure) will be driven off Inherited state selection, whereas Sum({MyState<Year = $::Year>} Measure) will be driven off MyState selection except for Year selection which will be driven off Inherited selection. Does that make sense?

Best,
Sunny

Re: Alternate States ( Only inherited state data should be seen in newly created State)

nitin_01 — Thu, 05 Mar 2020 13:59:54 GMT

Glad to hear & Thank you for the response. MyState table should only show data displayed in Inherited state with respect to whatever selection done in Year (i.e. left join in front end - assuming Inherited table as my left table).

Regards,

Nitin.

Re: Alternate States ( Only inherited state data should be seen in newly created State)

sunny_talwar — Tue, 10 Mar 2020 13:41:56 GMT

Awesome

Re: Alternate States ( Only inherited state data should be seen in newly created State)

nitin_01 — Fri, 03 Jul 2020 14:46:57 GMT

Cracked it, i am sure you will understand below code.

Count( [Participant Code] = P({$} [Participant Code]) * P({My_State<with selection filter criteria>}).

Thanks Sunny for your precious time.

Regards,

Nitin.