topic Re: Bar Charting percentages in QLikview in QlikView

Bar Charting percentages in QLikview

gwenngannon — Thu, 21 Jun 2018 20:49:56 GMT

HI I am looking for help to see “ percentages of the total” in the bar chart each month rather than just the balances

I have tried relative with no luck, I have tried to write an expression to divide the above expression by with no luck

Please help me write an expression to provide the results I’m looking for each month

Dimensions = Month End

= TYPE

Expression =

= sum({<L_STATUS ={'NPFM'},MONTH=,QUARTER=,YEAR= , [Month End]={">=$(=AddMonths(MonthStart(vSelectedMaxDate),-3))<=$(=AddMonths(MonthEnd(vSelectedMaxDate),1))"}>}(L_BAL_NET_CURRENT))

EX: results per type for 05/31/2018

CML = 20.80

MTG = 6.63

CNS = 1.15

TTL = 28.58

I would like this to see percentages of the total in the chart

CML = 20.8 / 28.58 = 72.7%. , MTG = 6.63 / 28.58 = 23.196%...and so on

Hope these examples help -thank you

Re: Bar Charting percentages in QLikview

vishsaggi — Thu, 21 Jun 2018 21:42:55 GMT

Did you try below?

= Num(Sum(Yourexpression)/Sum(TOTAL L_BAL_NET_CURRENT), '#,##0.00')&'%'

Re: Bar Charting percentages in QLikview

gwenngannon — Thu, 21 Jun 2018 22:23:42 GMT

thanks, yes I tried that but the percentage was by the full four months worth of balances-

Re: Bar Charting percentages in QLikview

gwenngannon — Thu, 21 Jun 2018 23:12:53 GMT

I think I have it thanks for taking the time to look at it, I played with the total and added month end aggregation :

=num(sum({<L_STATUS ={'NPFM'},MONTH=,QUARTER=,YEAR= , [Month End]={">=$(=AddMonths(MonthStart(vSelectedMaxDate),-3))<=$(=AddMonths(MonthEnd(vSelectedMaxDate),1))"}>}(L_BAL_NET_CURRENT)),'$##,###')
/
SUM( TOTAL <[Month End]> {< L_STATUS ={'NPFM'},MONTH=,QUARTER=,YEAR= , [Month End]={">=$(=AddMonths(MonthStart(vSelectedMaxDate),-3))<=$(=AddMonths(MonthEnd(vSelectedMaxDate),1))"}>}L_BAL_NET_CURRENT)