Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
gianniko
Contributor III
Contributor III

Display value regarding length

Hi, I created a table and I want to display the values only if the words are composed of 11 digits.

I thought of doing this:   =[ΤΟΜΕΙΣ6] if(len([ΤΟΜΕΙΣ6]) =11)

( with TOMEIZ6 the name of the column ), but of course it doesn't work.

 

Thank you in advance!!

1 Solution

Accepted Solutions
JordyWegman
Partner - Master
Partner - Master

I wouldn't advice the use of calculated dimensions, but you can use:

if(len([ΤΟΜΕΙΣ6]) =11, [ΤΟΜΕΙΣ6])

Jordy

Climber 

Work smarter, not harder

View solution in original post

2 Replies
JordyWegman
Partner - Master
Partner - Master

I wouldn't advice the use of calculated dimensions, but you can use:

if(len([ΤΟΜΕΙΣ6]) =11, [ΤΟΜΕΙΣ6])

Jordy

Climber 

Work smarter, not harder
gianniko
Contributor III
Contributor III
Author

Thank you so much!! I was close haha