Qlikview Class function dynamic calculation

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Qlikview Class function dynamic calculation

raman_rastogi — Wed, 19 Sep 2018 07:41:34 GMT

try this

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

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

Regards

Raman

topic Qlikview Class function dynamic calculation in QlikView

Qlikview Class function dynamic calculation

Re: Qlikview Class function dynamic calculation