Pick Match Function - not bypassing selection in Set Analysis

[renuka_sasikuma]

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

[kaushiknsolanki]

Hi,

Your syntax is wrong. It should be as below.

SUM({1}Value)

Regards,

Kaushik Solanki

[renuka_sasikuma]

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.

 

[agigliotti]

Hi @renuka_sasikuma ,

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

Best Regards

[renuka_sasikuma]

Hi All,

Please find the attached test application for your reference.

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

[tresesco]

Try this:

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

[chethan_ashoka_]

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

Can anyone help.

[anat]

=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)
)

[chethan_ashoka_]

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

[anat]

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