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: 
Death4Free
Contributor III
Contributor III

Variable in Class function

Is it possible to use variable as offset in Class function?

I create dimension:

=Class(
sales,
0.05,
'x',
$(vMinSales)
)

vMinSales: Min(Aggr(sum(sales), myDimension))

But it doesnt work - Invalid dimension error.

 

1 Reply
marcus_sommer

Yes, it's possible but the variable must return a dimension or a value and not an expression. In your case I'm not sure that defining the fourth parameter will be very useful. Beside this the following might be what do you looking for:

Class(sum(sales), 0.05, 'x', $(=vMinSales))

- Marcus