Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hammermill21
Contributor II

Variance from month to month

Hello,

I'm trying to use a waterfall chart to show the variance from month to month but I'm just not getting it to work correctly. To calculate each month percent I use this expression:

For Feb:

(Count({<[UMHC SYSTEM]={'100%'},[EC-LS-EM]= {'EC'}, Month = {'Feb'}>} [UMHC SYSTEM])/16  )

/

(  Count({<[EC-LS-EM]= {'EC'}>} EP#) / (16 * count({<Date={'<=$(=today())'}>}distinct Month))  )

Which would be 42%

then for March, it is:

(Count({<[UMHC SYSTEM]={'100%'},[EC-LS-EM]= {'EC'}, Month = {'Mar'}>} [UMHC SYSTEM])/16)

/

(Count({<[EC-LS-EM]= {'EC'}>} EP#) / (16 * count({<Date={'<=$(=today())'}>}distinct Month)))


Which would be 50%

So what I'm trying to show the variance from month to month, depending what months are selected. How can I go about doing that?

Thanks!