Classic Search

shahafei2 · ‎2018-12-02

Hi all, I'm having an issue with the pick(match()) function i'm loading a table as part of the script that contains two ranking fields per product Product,Rank A,Rank B I'm p...

Pick and Match example · ‎2016-08-09

Hi Guyz, Help me a simple example with pick and match.

jworthulf · ‎2022-05-24

Customer Support, I’m using Pick(Match(ValueList())) to populate my chart, it is working correctly on the first 2 expressions, but will not generate the numbers in the 3 rd e...

NicolasAimain · ‎2024-02-08

Dear all, I encounter an unepxected behaviour using pick match we have two not linked table, 1 factable, 1 technical table with one unique Dimension I have a calculation with set anaysis to l...

andrea0901 · ‎2021-06-23

...xample for Trans Type= ABC and Trans Type HL= Financial transactions the color should be Grey, and so on from other Trans Type 's as well. i tried doing using pick match but it is not working. i...

poklegoguy · ‎2024-07-18

...alueList('Sales', 'Customer', 'Profit') For the measures, the 'Values' column have to be calculated and the 'Targets' column is static. Below are the expressions I used: Pick(Match(ValueList('S...

data_guru_001 · ‎2018-07-26

...mount represents its own column header/expression. My idea, and this is where my question lies, is if I can utilize PICK(MATCH(VALUELIST... where I create a value list of something like ValueList('W...

risabhroy_03 · ‎2022-06-22

Can anyone please explain me how this pick match is working - =Pick(1+Match(-1, (Company_Code=225 AND [Warehouse Set_Inventory]=700) or (Company_Code=225 AND left([Invoice No FG_GIT],3)='G...

ashis · ‎2017-08-01

Hi I want to remove nested if condition with pick and match , and try to create bucket . My if conditions are working fine. I am trying the same with pick and match function , could you please h...

EMaebe · ‎2022-02-01

...lag, 'A','B','C'), 'Group 1', if(match(Flag, 'D','E','F'), 'Group 2', 'if(match(Flag, 'G'), 'None') or should I use pick match? If so, how would that formula be structured? A coworker shared t...

Classic Search

Search

Search the Community

Pick(Match()) in Pick(Match()) or Pick(Match(aggr(...

Pick and Match example

Pick(Match(ValueList

Pick match not working as expected

pick match function

Find the count of rows that matched the conditions...

Using ValueList with Pick(Match(

Pick Match

Pick and Match function

Pick Match vs If Match: grouping a dimension