Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've below data.
ID | New | Value |
1 | abc | 123 |
1 | abc | 456 |
1 | abc | 789 |
2 | efg | 963 |
I'm using the below IF statement to show the three values if I select 'abc' but it is showing only value '123'
if(match(ID,'1') and match(New'abc'),'123',if(match(ID,'1') and match(New,'abc'),'456' ,
if(match(ID,'1') and match(New'abc'),'789')))
I'm looking for an IF Statement to show all the three values (123, 456, 789) if I select 'abc'.
Regards,
Vikas
Hi, you need third dimension to separate 3 rows where ID = 1 and New = abc, because now these 3 rows are identical and if you are using 'if' to create 3 different Values, logic works so, that Value is applied for first true condition of 'if' and it is '123'.
If() will return the first value for which the condition is true
and your conditions are the same for all three ifs() !
so it's simply returning the first value the condition returned true
Where exactly do you want to show these three values? not sure what you are trying to achieve here
you can try below
Table Chart
Dimension = ID
Measure = if(GetselectedCount(ID) ,Concat(Distinct Value,', '))