topic Re: qlikview table. Format a background cell based on condition. like expression in QlikView

qlikview table. Format a background cell based on condition. like expression

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

Can you change a background cell of a field based on a condition.

Currently the Pivot table has this option but not the Table object.

Can anybody confirm ?

Thanks

Re: qlikview table. Format a background cell based on condition. like expression

kaushiknsolanki — Thu, 29 Mar 2018 04:03:07 GMT

Hi,

You are right, Table object doesnt have this functionality.

You should use Straight table instead of table box to get the functionality you want.

Regards,

Kaushik Solanki

Re: qlikview table. Format a background cell based on condition. like expression

Anonymous — Thu, 29 Mar 2018 07:00:01 GMT

Thanks Kaushik for recommendation of the Straight table.

Problem with Straight Table, it does not provide the horizontal scroll bar.

The formating of columns is limited.

Have we reach a limitation in qlikview ?

The user wants to see over 30 columns like excel in a table. (hence need to scroll to the right)

with condition formating that exists with excel cells. Such as change background colour based on a rule.

Re: qlikview table. Format a background cell based on condition. like expression

olivierrobin — Thu, 29 Mar 2018 07:29:56 GMT

hello

if you use a straight table, you can change the background color

qv tries to show all the dimensions and show the scroll bar for the expressions

try to limit then number of dimensions and resize tour table

Re: qlikview table. Format a background cell based on condition. like expression

Anonymous — Thu, 29 Mar 2018 07:49:07 GMT

Thanks Olivier,

However my straight table I cannot make it smaller.

meaning i cannot seem to change the width smaller.

it keeps same size even when change the Width in caption.

The scroll bar should have an option to show both vertical and horizontal.

Thanks

Re: qlikview table. Format a background cell based on condition. like expression

olivierrobin — Thu, 29 Mar 2018 07:57:05 GMT

look at what i have

it's a straight table wirh horizontal et vertical scroll bar

Re: qlikview table. Format a background cell based on condition. like expression

Anonymous — Thu, 29 Mar 2018 08:14:57 GMT

Appreciate that. But for some reason the horizontal bar will never appear

It seems when click on Presentation--->tick Always fully expanded

it move the border of the right table to FULL length...hence it seems it

width is unlimited.

version of qlikview is 12.0.20400.0 SR5 64-bit

Re: qlikview table. Format a background cell based on condition. like expression

olivierrobin — Thu, 29 Mar 2018 08:30:52 GMT

check in disposition,if "adjust to size of data" is selected

Re: qlikview table. Format a background cell based on condition. like expression

Anonymous — Thu, 29 Mar 2018 09:11:15 GMT

I see the problem

The scroll horizontal bar will never appear under the dimensions on the

left hand side. Meaning if you have more than 3 dimensions say 20

it will only show the scroll bar when you put fields as columns on the top of the pivot table

which looks fairly ugly,

So the request was to show the fields and scroll to the right (horizontal)

this can be done in standard table...but the table functionality object lacks cell formatting.

Re: qlikview table. Format a background cell based on condition. like expression

a_mullick — Thu, 29 Mar 2018 10:51:29 GMT

It may be a quirk rather than a 'feature', but format your straight table (chart) as you want, then embed it in a container object and size that to something smaller than the size of the table. When it is published on the web, it will have a horizontal scroll bar. You can check the effect by using WebView in your QV desktop edition.

Thanks,

Azam

Re: qlikview table. Format a background cell based on condition. like expression

kaushiknsolanki — Thu, 29 Mar 2018 11:04:08 GMT

Hi,

You can try below trick.

Create a composite key in script with the least level of granularity you want in chart.

Create a straight table add that Key as dimension and add all other dimensions as expression in straight table.

Go to presentation tab and click on the dimension and then click on Hide column.

This way you will have all fields as expression and you will get the required scroll plus the formatting options.

Regards,

Kaushik Solanki

Re: qlikview table. Format a background cell based on condition. like expression

Anonymous — Mon, 02 Apr 2018 02:22:11 GMT

Thanks Kaushik.

Above will work.

Unfortunately it is messy creating additional expressions.