Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
Death4Free
New 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
MVP & Luminary
MVP & Luminary

Re: Variable in Class function

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