topic Re: Unbold a partial sum in QlikView

Unbold a partial sum

sibrulotte — Fri, 19 May 2017 14:47:16 GMT

hi,

creating a pivot table, with 4 dimensions, one of which is horizontal. Making a partial sum for all dimensions.

The default is that the partial sum will be bold. Is there a way to avoid that. Please don't mention custom cell format, as Custom cell format will only add bold if there were none before, and i haven't added any.

Also, expression text format with dimentionality will not work since, again, I can only specify to actually make it bold, but I don't want that...

Any ideas on that otherwise?

Re: Unbold a partial sum

Anil_Babu_Samineni — Fri, 19 May 2017 14:51:23 GMT

May be this for BG Color of that expression

If(Sum(TOTAL [amount of protein])>0, White())

Re: Unbold a partial sum

sunny_talwar — Fri, 19 May 2017 14:52:55 GMT

May be you can use Pick(Dim...) way

Re: Unbold a partial sum

sibrulotte — Fri, 19 May 2017 15:02:24 GMT

Sunny, that's a good result. To make it work, I have to have as many Dim values as I have results in my Type field?

Re: Unbold a partial sum

sunny_talwar — Fri, 19 May 2017 15:04:47 GMT

No, regardless of the number of Types, you would need 2 values in Dim.... Instead of you needed to show Total and Average, that's when you will need 3

Dim = 1 -> Type

Dim = 2 -> 'Total'

Dim = 3 -> 'Average'

...

so on and so forth...

Within Type, you can have hundreds of thousands of types

Re: Unbold a partial sum

sibrulotte — Fri, 08 Sep 2017 20:09:38 GMT

Hi,

I was currious,

if a selection is made, and no values exist for meat under that selection, is there still a way to have the colomn show up but with zeros?

The suppress zero values does not work in that circumpstance.

for the exemple above, if Chicken and salad are selected, I,d still want the meat colomn to show up but with zeros...

Re: Unbold a partial sum

sibrulotte — Wed, 13 Sep 2017 19:25:12 GMT

Are there any heads out there that can help?

Re: Unbold a partial sum

sunny_talwar — Wed, 13 Sep 2017 19:32:26 GMT

May be convert this into multi expression chart

Re: Unbold a partial sum

sibrulotte — Wed, 11 Oct 2017 23:36:35 GMT

Hi Sunny,

thank you for the input. I used to have a table that was all expressions, but I wanted my client to be able to click on an amount anf have the selection be made on the meal and type they clicked on, and have a trigger to bring them to a detailled analysis.

If I go back to a bunch of expressions, I lose that...

Re: Unbold a partial sum

sunny_talwar — Thu, 12 Oct 2017 01:38:34 GMT

Not sure what to tell ... may be someone else can offer better help

Re: Unbold a partial sum

marcus_sommer — Thu, 12 Oct 2017 09:17:00 GMT

Did you try to change the tableformat within the tab design maybe to simple, list or classic - maybe then combined with a transparent cell-background and adding/changing various layout-options per the attribute expressions and/or the custom cell-format to your wished layout?

- Marcus

Re: Unbold a partial sum

Anonymous — Mon, 04 Jun 2018 19:44:02 GMT

Simon,

The way to do this is simple. First, convert your pivot table to a straight table. Then, click the design grid icon next to the format painter tool icon.

Now, hover over the total columns in your straight table, right click, and select "Custom Format Cell." You will need to unbold each total cell individually, and you may want to edit its background color while you are there.

Then, change the chart back into a pivot table, and your total columns will be unbolded. Voila.

Best,

-Dennis