topic Re: how use set expression with a String field in App Development

how use set expression with a String field

pascos88 — Wed, 11 Apr 2018 12:09:50 GMT

Hello,

how can I write this expression ?

=maxstring({<CampaignID = {$(v_Last_Year)}>}MissingCompanyName)

MissingCompanyName is a string, maybe the aggregation is wrong.. Coould I use something else in stead of maxstring?

Thabks for any help

Re: how use set expression with a String field

sunny_talwar — Wed, 11 Apr 2018 12:14:11 GMT

You can use MaxString, MinString or Only functions

Re: how use set expression with a String field

pascos88 — Wed, 11 Apr 2018 12:23:57 GMT

I am tring qwith this:

= Aggr(Only({1<CampaignID = {$(v_Last_Year)}>} MissingCOmpanyName), MissingCOmpanyName)

but why it change with my selections, even if I pu 1 in the formula?

Re: how use set expression with a String field

sunny_talwar — Wed, 11 Apr 2018 12:25:17 GMT

What is v_Last_Year? and you are using this as a dimension?

Re: how use set expression with a String field

pascos88 — Wed, 11 Apr 2018 12:27:23 GMT

v_last_year is a variable created in the load script.

I am just outting this formula in a column of table

Re: how use set expression with a String field

sunny_talwar — Wed, 11 Apr 2018 12:28:35 GMT

I am just outting this formula in a column of table

As a dimension or Measure?

v_last_year is a variable created in the load script.

How do you define it?

Re: how use set expression with a String field

pascos88 — Wed, 11 Apr 2018 12:33:02 GMT

LET v_Last_Year = Peek('LastCampID', 1, 'LastCam_ID');

v_Last_Year it is a number 1000102 (it workd fine)

I use the formula as dimension

Re: how use set expression with a String field

sunny_talwar — Wed, 11 Apr 2018 12:45:05 GMT

Okay, it make sense, now if you have expressions, may be you need to ignore selection in them also... may be using the same set analysis that you used here

Re: how use set expression with a String field

pascos88 — Wed, 11 Apr 2018 12:50:32 GMT

using

= Aggr(Only({1<CampaignID = {$(v_This_Year)}>} CampaignID), CampaignID)

looks that the set expression doesn't work. I mean I have two CampaignID, and once I change select in this filter, the column change values..

Looks that {1<CampaignID = {$(v_This_Year)}>} doesn't do his job..

How can be ?

Re: how use set expression with a String field

sunny_talwar — Wed, 11 Apr 2018 12:53:08 GMT

What all dimensions and measure do you have in your chart? Can you share all of them here?

Re: how use set expression with a String field

pascos88 — Wed, 11 Apr 2018 12:56:28 GMT

HI,

now it work just with this...

= maxstring({<CampaignID={$(v_Last_Year)}>} MissingCOmpanyName)

I don't know why didn't works before.. Thanjs for your time