topic Toggle between Filterpane/Expression dimensions using Pick/ Match in App Development

Toggle between Filterpane/Expression dimensions using Pick/ Match

vkish16161 — Thu, 15 Jun 2017 15:42:51 GMT

All,

I have a question.

We have a Value_Selector field in the DM with these 3 values 'A','B','C'.

We also have 3 separate flags in the DM named 'A','B','C'. The values for these flags are 0 and 1 only.

We have an expression of the form

Sum(Sales * if(Value_Selector='A',,

if(Value_Selector='B',,

if(Value_Selector='C',, ))))

Can I use a Pick/Match for this?

BIG Caveat: What if the user selects multiple values. (Like A and B or All of them)

vkish16161 — Thu, 15 Jun 2017 15:56:26 GMT

ALL, just an update.

I used this and it looks like it works, but only in a filterpane. I still can't get the expression to work properly.

(pick

(Alt(match([Area Universe],'DSP','PC','AC'),'4'),[DSP Flag],[PC Flag],[AC Flag],[AC Flag])

)

P.S for the caveat - I have simply used the Alt function.

sunny_talwar — Thu, 15 Jun 2017 16:23:42 GMT

How about this?

Sum(Sales * $(=If(GetSelectedCount([Area Universe]) = 1, '[' & [Area Universe] & ' Flag]', '[AC Flag]')))

vkish16161 — Thu, 15 Jun 2017 17:41:50 GMT

Good solution as usual Sunny. Will try this out.

Thanks for the help.