Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor II

Variance Month to Month


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?


Community Browser