Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlikview Class function dynamic calculation

Hi Team

Basically my requirement is to get the bucket/interval of values on x-axis based on user input. If usre enters 10. then the x-axis should display 0-10,10-20,20-30,30-40,etc.

For this, I am using class function in dimension.

The expression is like:

=Class((Sum([Total net sales USD])/$(vActualVolume_UoM)),vL.BandWidth)

But this expression is not working in calculated dimension.Dimension:=Class((Sum([Total net sales USD])/$(vActualVolume_UoM)),vL.BandWidth)

Expression: =$(vActualVolume_UoM)

Variables:

vActualVolume_UoM: is calculated volume based on user selection. There are 2 types of Volume which user can select based on the selection value will be stored in the variable.

vL.BandWidth: User input number like 1,2,3,4,5,etc.

Thanks in Advance!

1 Reply
raman_rastogi
Partner - Creator III
Partner - Creator III

Hi

try this

Class(([Total net sales USD]/$(vActualVolume_UoM)),vL.BandWidth)


Or


Class((Aggr(Sum([Total net sales USD]), Dimension Field )/$(vActualVolume_UoM)),vL.BandWidth)



Regards

Raman