topic Re: Straight Chart Scroll bars in QlikView

Straight Chart Scroll bars

Mon, 03 Mar 2014 14:56:42 GMT

Hello Guys,

I have a table which contains 15 columns.I want to show all of them in straight chart and want to apply scroll bars within this chart.I have tried but I am not able to use scroll bar in dimensions,i can only apply scroll bars in expression I set.

Also i want to change the background colour and font colour of bar where I show dimension names.But i am not able to do that.

Re: Straight Chart Scroll bars

alexandros17 — Mon, 03 Mar 2014 15:00:54 GMT

Unfortunately scroll bar apply only to expressions ....

Re: Straight Chart Scroll bars

Mon, 03 Mar 2014 15:07:20 GMT

Move the 14 of 15 dimensions in expressions.

And for the background color, set Document Properties -> Styling Mode -> Advanced or active Design Grid

and then right click on cell of dimension and choose Custom Format Cell.

Hope this helps.

Re: Straight Chart Scroll bars

Mon, 03 Mar 2014 15:29:28 GMT

thanks mario for reply,I have used dimension in expression but this results in add of one extra row,which i ddint need.Also i didnt get any option of Custom format cell ,can you please tell me how I can get it,.I just want to change the background color of that row which shows name of dimensions.

Re: Straight Chart Scroll bars

Mon, 03 Mar 2014 21:18:41 GMT

Active the Design Grid in the Design panel before right click on the cell...

Re: Straight Chart Scroll bars

Anonymous — Mon, 03 Mar 2014 22:00:49 GMT

Vote here: http://community.qlik.com/ideas/2669

Re: Straight Chart Scroll bars

Mon, 03 Mar 2014 22:09:45 GMT

You can move your dimensions as expresions and add an extra expresion with 1 as a value. If i am not in wrong if you use pivot table you can hide this column. Remember that you can have a pivot table ever in expand.

Regards

Re: Straight Chart Scroll bars

Tue, 04 Mar 2014 08:28:33 GMT

I am sorry but i am not able to find the Design Grid option.I am currently using table box.

Re: Straight Chart Scroll bars

Tue, 04 Mar 2014 12:18:02 GMT

Thank you guys for help.I have done it,using Table box.It contains scroll bars for field.Also change the background color of field name row by clickng Active Design grid under Settings>user Preference>Deign