topic Straight Table Text Formatting in QlikView

Straight Table Text Formatting

Wed, 03 Mar 2010 06:08:59 GMT

G'day again everyone - Another text formatting question.

I have attached a QVW so you can have a look at what I am trying to achieve here since it would be very hard to explain it without a visual aid. I will upload when I can figure out this permission error...

In our report we use ~50 expressions, but this sample sheet only uses a few. There are some fields that have been intentionally left blank, usually with an expression like =' ' to make sure there is nothing shown in the cell.

The problem I am facing is I don't want the expressions to all be bold. Only a few select ones. For example [Profit Loss Implact], [Revenue Impact] and [Total Revenue Impact] I want bolded, but the rest I want left normal.

I hope this is possible because using a straight table with ~50+ expressions bolded isn't pretty on the eyes.

Note: We are using it horizontal deliberately, if only it was that easy...

Straight Table Text Formatting

Wed, 03 Mar 2010 09:30:06 GMT

Hi Kieran,

if this is just about making some expressions bold then go to the expressions and expand an expression you want to be bold and under text format enter '<b>' (including the quotes) as Definition.

This will just make this particular expression bold. You can even use formulas to make the expression only bold if it is within a certain range. (Kinda like visual cues, but a lot more powerful).

The same applies to the property Background Color.

Cheers, Lukas

Straight Table Text Formatting

Wed, 03 Mar 2010 23:30:07 GMT

G'day Lukas;

This is very hard to demonstrate without an example/sample file to show you. I am having some technical problems here that are preventing me from uploading a .qvw so please heck back when I get this fixed up.

Your answer is not the right answer I am looking for. I am sure you will understand when I upload the file.

Cheers;

Kieran

Straight Table Text Formatting

Wed, 03 Mar 2010 23:43:17 GMT

Well, this is all I can do for now - if you go to my profile page you can download the .qvw file from there, under the folder 'Text Formatting'.

Now as you can see the straight table has all the expressions Bolded. Whereas the Pivot table (Copy/Pasted and changed to Pivot) has only the fields I want Bolded)

So there are two 'solutions' I am looking for - EIther:

Work a way to only bold certain expressions in the Straight Table format.

Work a way to format the size of columns in the Pivot Table format so they are not all equal width.

-Kieran

Straight Table Text Formatting

Fri, 05 Mar 2010 05:42:37 GMT

Here is the file I was talking about. Seems like the upload issue has passed.

Any ideas?

Straight Table Text Formatting

Fri, 05 Mar 2010 22:20:02 GMT

Hi Kieran, I tried & tried but couldn't get it to work.

I though it could be solved by using the advanced styling option but this doesn't help either.

Straight Table Text Formatting

Mon, 08 Mar 2010 22:50:31 GMT

Yeah we have had three people here have a red hot go at it and haven't made any progress...

Straight Table Text Formatting

Tue, 09 Mar 2010 23:28:33 GMT

Anyone else got any new ideas or should I just accept that it can't be done?

Straight Table Text Formatting

larsc — Tue, 09 Mar 2010 23:41:49 GMT

You may look at the sample application "Data Visualization" included in QlikView, tab "Butterfly".

Straight Table Text Formatting

Wed, 10 Mar 2010 00:03:38 GMT

I can't find this. Where do I look?

Straight Table Text Formatting

larsc — Wed, 10 Mar 2010 09:12:44 GMT

It is in version 9. Download and take a look at how this is solved. It is one of the sample applications installed with QlikView.

Straight Table Text Formatting

Wed, 10 Mar 2010 21:03:12 GMT

Unfortunately I am on 8.5 and won't be on 9 for a while. 😞

Straight Table Text Formatting

Mon, 22 Mar 2010 12:57:04 GMT

Hi Kieran,

have you been able to find a solution yet? This would be very useful ...

Thanks & Cheers, Lukas

Straight Table Text Formatting

Mon, 22 Mar 2010 23:15:27 GMT

Not a viable solution sorry.

Our current workaround is to use a messy pickmatch but the performance of the table using a 37 value pickmatch statement is very freakin' messy and slow.