topic Re: sorting, background colour and dimension expand in QlikView

sorting, background colour and dimension expand

Anonymous — Thu, 08 Oct 2015 06:43:06 GMT

Hi,

I am having the following in Straight table.

1) I need to do sort adjust back ground colour for a column and

2) I need an extra column where I can expand to see the rest of columns.

I am attaching required image and app.

please help me out.

Anonymous — Thu, 08 Oct 2015 11:37:35 GMT

required help

Peter_Cammaert — Thu, 08 Oct 2015 11:41:54 GMT

Straight tables do not allow you to group dimension values or rows. Use a pivot table instead.

To color individual cells, enable Design Grid and right-click on the cell you want to modify. Then select Custom Format Cell... from the menu.

Best,

Peter

SergeyMak — Thu, 08 Oct 2015 12:11:50 GMT

Hi John,

Please find attached.

You can use Dual to reorder your columns, but I would recommend to move this calculated dimensions into load script.

I also would not recommend to use this customised tables. You can do it, but you will have too many limitations

Regards,

Sergey