topic Re: Pick Match Function - not bypassing selection in Set Analysis in App Development

Pick Match Function - not bypassing selection in Set Analysis

renuka_sasikuma — Wed, 28 Apr 2021 06:32:53 GMT

Hi,

I have a field as Unit. When I select Unit, it should not affect my chart.

Tried using this expression : SUM({1}{<Unit=>}Value) along with Pickmatch, also with Pick(Match(Only(Unit)) but it is not working. Any guidance on this.

Unit	Value
1	760
2	50
3	300
Total	1110

Regards,

Renuka S

Re: Pick Match Function - not bypassing selection in Set Analysis

kaushiknsolanki — Wed, 28 Apr 2021 06:43:17 GMT

Hi,

Your syntax is wrong. It should be as below.

SUM({1}Value)

Regards,

Kaushik Solanki

Re: Pick Match Function - not bypassing selection in Set Analysis

renuka_sasikuma — Wed, 28 Apr 2021 07:08:55 GMT

Hi,

Please find the current expression which is there.

Expression:
=Pick(Match(Dim2,'A1','A2','A3'),
Sum(Sales)/Count(Distinct Date),
Sum(Gross)/Count(Distinct Date),
Sum(Revenue)/Count(Distinct Date)
)

I have a filter pane Dim1, when Dim1 is selected it should not make any changes in my pivot table.

Attaching a snapshot for reference.

Re: Pick Match Function - not bypassing selection in Set Analysis

agigliotti — Wed, 28 Apr 2021 07:13:03 GMT

Hi @renuka_sasikuma ,

To achieve that you have to add {< Dim1 >} in all your expressions.

Best Regards

Re: Pick Match Function - not bypassing selection in Set Analysis

renuka_sasikuma — Wed, 28 Apr 2021 07:48:14 GMT

Hi All,

Please find the attached test application for your reference.

I have made the adding of {<Dim1>} in expression still it is changing.

Re: Pick Match Function - not bypassing selection in Set Analysis

tresB — Wed, 28 Apr 2021 07:56:40 GMT

Try this:

=Pick(Match(Only({<Dim1=>}KPI),'C1','C2','C3'),
Sum({<Dim1=>}Sales),
Sum({<Dim1=>}Gross),
Sum({<Dim1=>}Revenue)
)

Re: Pick Match Function - not bypassing selection in Set Analysis

chethan_ashoka_ — Tue, 07 Dec 2021 02:53:38 GMT

I'm also facing same issue, i have tried all the above solutions. But nothing worked.

Can anyone help.

Re: Pick Match Function - not bypassing selection in Set Analysis

anat — Tue, 07 Dec 2021 04:35:26 GMT

=Pick(Match(only({<Dim1=>}Dim2),'A1','A2','A3'),
Sum({<Dim1=>}Sales)/Count({<Dim1=>}Distinct Date),
Sum({<Dim1=>}Gross)/Count({<Dim1=>}Distinct Date),
Sum({<Dim1=>}Revenue)/Count({<Dim1=>}Distinct Date)
)

Re: Pick Match Function - not bypassing selection in Set Analysis

chethan_ashoka_ — Tue, 07 Dec 2021 04:39:50 GMT

It's still filtering out based on selecting Dim1. please provide qvw file if possible.

Re: Pick Match Function - not bypassing selection in Set Analysis

anat — Tue, 07 Dec 2021 04:55:35 GMT

i have used dummy data ,can u share ur qvw file ,i will do the changes

Re: Pick Match Function - not bypassing selection in Set Analysis

anat — Tue, 07 Dec 2021 05:01:46 GMT

can u try below one using getfieldselection:

if(getfieldselections(DIM2)='A1',Sum({<Dim1=>}Sales)/Count({<Dim1=>}Distinct Date),
if(getfieldselections(DIM2)='A2',Sum({<Dim1=>}Gross)/Count({<Dim1=>}Distinct Date),
if(getfieldselections(DIM2)='A3',Sum({<Dim1=>}Revenue)/Count({<Dim1=>}Distinct Date)
)))