Conditional statement based on string values ?

Answered

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.

Comments

20 comments

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.

2

Comment actions Permalink
Delsaran Bigglesworth January 29, 2019 15:40

Any up date on this feature?

3

Comment actions Permalink
David Bauernschmidt March 01, 2019 03:15

Any update?

1

Comment actions Permalink
Crystal Mosley March 01, 2019 19:29

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

2

Comment actions Permalink
Anthony Nater March 01, 2019 19:55

same here. any update?

1

Comment actions Permalink
Sandy Ward March 04, 2019 16:51

ditto - this would be very helpful!

2

Comment actions Permalink
Tim Kessler March 08, 2019 18:57

Any update on this?

2

Comment actions Permalink
Angelina Karsa April 18, 2019 13:57

any updates- as this is a very useful functionality

Thanks

1

Comment actions Permalink
David Hertzberg April 18, 2019 16:36

How to prioritize this ???

David

2

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

1

Comment actions Permalink
Alex Lin October 07, 2019 20:56

Any update? Thanks!

1

Comment actions Permalink
Cheri Helgens December 18, 2019 21:00

Katie Garrison - is there an update on this functionality yet?

3

Comment actions Permalink
Hamza Jap-Tjong December 19, 2019 11:41

I struggle with this aswell sometimes. However I use this workaround (not always applicable)

case

when (COUNT([ID]), [COUNTRY]) >0 then 5 else 0 end

You can copy the when statement multiple times and filter the country field each time

0

Comment actions Permalink
Ido Darnell December 19, 2019 17:03

Hi All, just reposting my previous comment from above, as I see there's some interest on this, this solution is working for us:

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

ido.darnell@qbeeq.pl

QBeeQ.pl

Sisense Partner of the Year 2019!

1

Comment actions Permalink
David Peterson September 16, 2020 12:14

wow, issue is still outstanding since 2018.... glad. to see sisense product management really cares about the community.

7

Comment actions Permalink
Lucas Matter September 24, 2020 22:02

Hello there!

We hope we can see this basic feature soon. Do we have any answer?

1

Comment actions Permalink
Eshwar Sankar October 17, 2020 23:51

I would think this is a basic feature. I'm also trying to do something as simple as

if(Variable A > Variable B, 1,0) in the dashboard. Any update on this feature?

1

Comment actions Permalink
David Pitak November 17, 2020 18:34

Woud love to see an update on this. Converting some Tableau dashboards into our Sisense environment and missing this basic functionality is causing some extreme pain.

1

Comment actions Permalink
Kevin Matthews December 07, 2020 04:01

Would love to see this feature!

0

Comment actions Permalink
Bruce Jones December 30, 2020 21:17

Agree that this would be valuable. Just spent an hour on this and finally found this thread. This seems like a pretty easy feature to implement. Would make a lot of things easier.

Sisense team - thanks in advance for giving this some consideration.

0

Comment actions Permalink

Please sign in to leave a comment.

Comments

Didn't find what you were looking for?