Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
manisha10
Contributor III
Contributor III

Data changes on converting Date to Month format - Qlik Sense

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 

2 Replies
Thiago_Justen_

Hi @manisha10 ,

What is the expression do you use for bar height?

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
manisha10
Contributor III
Contributor III
Author

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