Conditional statement based on string values ?

Answered

Follow

Ankit Mandal

October 17, 2018 11:32

I am unable to find a way to use a conditional statement on a string field .

Ex. If [Country] ="India" then [Value] else Null 

Is there a way to do it in the dashboard formula instead of writing the formula in the elasticube ?

 

Thanks,

Ankit.

7

• 

  Katie Garrison October 27, 2018 15:10

  Hi Ankit,

  Currently front end IF and CASE statements work only on numerical numbers (not strings as you are trying to do). We are planning to add additional functionalities in future versions. Please see our documentation on the subject: Conditional Statements

  Also, feel free to submit your idea in our Ideas Forum, where it can gain traction through community input and upvoting.

  3

  Comment actions Permalink
• 

  Delsaran Bigglesworth January 29, 2019 15:40

  Any up date on this feature?

  1

  Comment actions Permalink
• 

  David Bauernschmidt March 01, 2019 03:15

  Any update?

  0

  Comment actions Permalink
• 

  Crystal Mosley March 01, 2019 19:29

  I'd like an update on this one as well. It's killing me. :)

  0

  Comment actions Permalink
• 

  Anthony Nater March 01, 2019 19:55

  same here.  any update?

  0

  Comment actions Permalink
• 

  Sandy Ward March 04, 2019 16:51

  ditto - this would be very helpful!

  1

  Comment actions Permalink
• 

  Tim Kessler March 08, 2019 18:57

  Any update on this?  

  1

  Comment actions Permalink
• 

  Angelina Karsa April 18, 2019 13:57

  any updates- as this is a very useful functionality

   

  Thanks

  0

  Comment actions Permalink
• 

  David Hertzberg April 18, 2019 16:36

  How to prioritize this ???

  David

  1

  Comment actions Permalink
• 

  Ido Darnell May 16, 2019 11:31

  Hi All,

  Just a thought here, given that CASE/WHEN statements within widget formulas aren't supported yet for strings, one can allocate a unique INT value for each of the different string values within the EC table, by adding a new column, then using the RANK() function, this way each string will be allocated it's own unique INT value, and then apply the CASE/WHEN statement on that.

  Assuming the value of 'India' receives the INT of 17 then:

  If( [Country_INT] =17 , [Value] , NULL )

  OR

  CASE

  WHEN [Country_INT] =17 THEN [Value]

  ELSE NULL

  END

   

  LMK if I can further clarify

  Ido

  QBeeQ.pl

  0

  Comment actions Permalink
• 

  Alex Lin October 07, 2019 20:56

  Any update? Thanks!

  0

  Comment actions Permalink

Please sign in to leave a comment.