topic Re: Dynamic Chart - formatting columns size and sorting in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Chart-formatting-columns-size-and-sorting/m-p/435312#M1162576 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>1. Don't think its possible (except you manage to use PostMessage() from VBScript <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />)</P><P>2. You can try to use =$() expressions (look at help 'dollar-sign expansions') to enchance your sample, they works not only with variables.</P></BODY></HTML> Mon, 22 Oct 2012 20:03:02 GMT whiteline 2012-10-22T20:03:02Z Dynamic Chart - formatting columns size and sorting https://community.qlik.com/t5/QlikView/Dynamic-Chart-formatting-columns-size-and-sorting/m-p/435311#M1162575 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I've found this beaultiful example of dynamic filtering. I would like to enchance it a little bit, adding some useful stuff:</P><P></P><P>1. How to make the chart to adjust column size, so that all the characters of each record is visible? I changed the ID adding some more characters, and as you see, the column is not wide enough now... can I automate this wight adjustment in macro code for each column in the "Dynamic chart" table?</P><P></P><P>2. How to add sorting to the "Dynamic chart" , quite simple one: the first expression in the table is sorted in descending order?</P><P></P><P>Thanks a lot for your help </P><P></P><P>//Draszor</P></BODY></HTML> Sat, 20 Oct 2012 18:18:36 GMT https://community.qlik.com/t5/QlikView/Dynamic-Chart-formatting-columns-size-and-sorting/m-p/435311#M1162575 2012-10-20T18:18:36Z Re: Dynamic Chart - formatting columns size and sorting https://community.qlik.com/t5/QlikView/Dynamic-Chart-formatting-columns-size-and-sorting/m-p/435312#M1162576 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>1. Don't think its possible (except you manage to use PostMessage() from VBScript <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />)</P><P>2. You can try to use =$() expressions (look at help 'dollar-sign expansions') to enchance your sample, they works not only with variables.</P></BODY></HTML> Mon, 22 Oct 2012 20:03:02 GMT https://community.qlik.com/t5/QlikView/Dynamic-Chart-formatting-columns-size-and-sorting/m-p/435312#M1162576 whiteline 2012-10-22T20:03:02Z