Data changes on converting Date to Month format - Qlik Sense

[manisha10]

Hi All!

I have a bar chart with data in percentage and date. whenever I change the date to months the bars reduce from 100% to 24%. 

code used: Date(Monthstart(timeid), 'MMM-YY' )

This works fine for other bar charts but for the % ones it does not work. Do you know any solution?

Qlik Sense Business 

[Thiago_Justen_]

Hi @manisha10 ,

What is the expression do you use for bar height?

[manisha10]

num(sum({$<[C1]={'loan'}>}balance)/sum(TOTAL <timeid>{[c1]={'loan'}>}[balance]),'###0 %')