Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
younlim91
Contributor II
Contributor II

Invalid Dimension Error, maybe set analysis?

Hi, I am getting "invalid dimension error" on the master item that I created.
I will use 'A', 'B', and 'C' for each field just to make you understand it easier.
this is just a part of my expression. it has multiple similar conditions like below.
if((min(A, B) - C)*24 > 336 and (min(A, B) - C)*24 <=672, 'in 4 week')

Labels (2)
1 Solution

Accepted Solutions
MayilVahanan

HI @younlim91 

FYI: We can't use Aggregation (like min, max) function in the dimension without aggr function.


Aggr(if((min(A, B) - C)*24 > 336 and (min(A, B) - C)*24 <=672, 'in 4 week'), YourDimensioFieldName)

or
Try to create the bucket in the script.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

1 Reply
MayilVahanan

HI @younlim91 

FYI: We can't use Aggregation (like min, max) function in the dimension without aggr function.


Aggr(if((min(A, B) - C)*24 > 336 and (min(A, B) - C)*24 <=672, 'in 4 week'), YourDimensioFieldName)

or
Try to create the bucket in the script.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.