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
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Kirsten
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
lironbaram
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
lironbaram
Partner
Partner

hi 

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

Kirsten
Creator II
Creator II

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

See attachment

AlbertoV
Partner
Partner

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

Kirsten
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

AlbertoV
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

lironbaram
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

Kirsten
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

Kirsten
Creator II
Creator II

Hi @AlbertoV 

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