Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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