topic Re: How to use concat in the variable in App Development

How to use concat in the variable

varunreddy — Wed, 22 Dec 2021 16:15:09 GMT

Hi All,

I have the field (A) and I have values B,C,D,E,F. I want to store all the values in the variable.

I am trying to convert

Sum({A = {'B','C','D','E','F'}Sales)

Sum({<A = {'$(vtest)'}>}Sales)

Where vtest = {'B','C','D','E','F'}

If I select B, then I should get the data by B else I need to see all the values.

Is this possible?

Thanks,

Varun

Re: How to use concat in the variable

sunny_talwar — Wed, 01 May 2019 18:36:51 GMT

May be this

Sum({<A *= {'$(vtest)'}>}Sales)

Re: How to use concat in the variable

varunreddy — Wed, 01 May 2019 18:39:29 GMT

Hi Sunny,

Thanks for the quick reply.

How can I create the vtest?

vtest = concat('A',',')?

Re: How to use concat in the variable

sunny_talwar — Wed, 01 May 2019 18:40:46 GMT

Is there a reason you want to create it using Concat?

Re: How to use concat in the variable

varunreddy — Wed, 01 May 2019 18:42:56 GMT

If nothing is selected, I wanted to select all the values. If they select the value, I want that value to be selected.

Re: How to use concat in the variable

sunny_talwar — Wed, 01 May 2019 18:49:04 GMT

So, why can't you just use this?
Sum({<A *= {'B','C','D','E','F'}>} Sales)

Why do you need Concat?

Re: How to use concat in the variable

varunreddy — Wed, 01 May 2019 18:50:41 GMT

If new value is added (i.e. If G is added), then it requires the manual effort.

Re: How to use concat in the variable

sunny_talwar — Wed, 01 May 2019 18:56:06 GMT

Lol, so why can't you just use Sum(Sales)? When nothing is selected, it will show the sum of sales for all A, but when one A is selected, it will show Sum of sales for just that A. Why do you need set analysis?

Re: How to use concat in the variable

varunreddy — Wed, 01 May 2019 19:02:24 GMT

Sorry for the confusion. I have renamed the field A as Z and using it in different table. But in the dashboard I am using A as the filter. If I select A, then few values are not displaying. So I thought if we create the variable and use it in the set expression, it will work.

Sum({<Z = {'$(vtest)'}, A>}Sales)

Re: How to use concat in the variable

sunny_talwar — Wed, 01 May 2019 19:07:38 GMT

May be you need this?

Sum({<Z = p(A), A>}Sales)

Re: How to use concat in the variable

varunreddy — Wed, 01 May 2019 20:13:58 GMT

Hi Sunny,

This worked. Thanks for your time.

Cheers,

Varun