How to create bold and red text by condition in pivottable?

[#1]

Heyho!

I want to constitute data in red color and bold text if the value is above 4%.

The color is working with the following skript in the formula for the background color:

if( (Sum(Frachtkosten)/Sum(Verkaufspreis)) >0.04, red())

but the bold text is not. I tried with

if( (Sum(Frachtkosten)/Sum(Verkaufspreis)) >0.04, '<B>')

in formula field for background color and textcolor.

Besides,

1.: is it possible that qliksense uses the percentage number as a value in the skript, which means in this example 4% instead of 0.04?

2.: is it possible to move the listboxes, respectively fieldboxes, over all worksheets so that they are arranged at the same place on every worksheet (this would be a question for qliksense and qlikview)

3.: is it possible to put the listboxes/fieldboxes in qliksense at the top of the worksheet as in qlikview, like its illustrated in the picture below?

4.: is it possible to move fieldboxes, diagrams etc. really accurate (per pixel) like in qlikview?

Best regards Leon

[Michael_Tarallo]

Hi Leon, from the screenshot it appears you are using QlikView. I will move this discussion to the QlikView forums.

Mike

[giakoum]

it works for me :

[giakoum]

1. No

2. You can copy objects and paste them as linked on other sheets. this way, a change is applied to all, and you can even set the position and size (right click --> Linked Objects --> Adjust position and size)

3. Don't know about QlikSense. You should make 2 separate questions, one in each corresponding forum

4. Don't know about QlikSense. You should make 2 separate questions, one in each corresponding forum

[#5]

Hey Mike,

Hey Ioannis,

thanks for the answers so far. I just posted the screenshot from Qlikview to show what I want to do in QlikSense. So could you please move it back again to the Qliksense forum?

Best regards

Leon