Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Expression error in Dimension for table selection

I would like to create a dimension to make a selected view (True) in a table . However the expression in the dimension turns an error while it is similar to another expression that is working. The field I am referring to (Exceeds) is a caculated field. What is wrong?

See attachment

1 Solution

Accepted Solutions
Partner
Partner

hi 

if Exceeds is calculated field than you need to replace him in the expression with the expression you use to calculate him 

the expression you wrote only work for fields that loaded to app 

not calculated dimension or master items 

View solution in original post

8 Replies
Partner
Partner

hi 

try : if(Exceeds='True',Exceeds)

Creator II
Creator II

Hi @lironbaram  thanks. It still throws an error. I  think there is something strange

See attachment

Partner
Partner

It looks like the field "Exceeds" doesn't exist in your model. 

Creator II
Creator II

Hi @AlbertoV 

Thanks. It exists,  but it is a calculated field. How can I make an expression with a calculated field? Or is there another way I can make a selected view of the table?

See Exceeds available in the table in the attachment

Partner
Partner

Fields should show in orange font on the expression editor and as you can see on your screenshot it's showing black. Can you see it on the field selection area? 

Screenshot.jpg

Partner
Partner

hi 

if Exceeds is calculated field than you need to replace him in the expression with the expression you use to calculate him 

the expression you wrote only work for fields that loaded to app 

not calculated dimension or master items 

View solution in original post

Creator II
Creator II

Hi @lironbaram 

It works. Thanks!

Somehow it is a bit strange how it works because also calculated field is not available in "Fields" on the left side. Which means you can not drag the dimension to e.g. a filter. I can image you would need to use calculated fields in this way too

Kirsten

Creator II
Creator II

Hi @AlbertoV 

Thanks. Yes it was not visible because it is a calculated field. See post below