topic Re: Text format on pivot table doesn't work in QlikView

Text format on pivot table doesn't work

gf — Sat, 16 Nov 2024 20:58:50 GMT

Hello all,

I have a strange problem. I have a pivot table where I want to display some cells bold.

The problem is, it doesn't matter if i try it with a condition ( IF(myColumn='xxx','') ) or with all the values (='<B'>) in a column.

The columns where I want to set cells bold come from a LOAD where i use a CONCATENATE.

Did I miss to set a specific option or something?

The strange thing is, in the same project, different tab, I have a pivot table where I use a conditional format text like =IF(Wildmatch(myColumn,'*xxx*'),'') and this works perfectly.

Thanks in advance!

Regards

Re: Text format on pivot table doesn't work

shiveshsingh — Fri, 26 Apr 2019 06:36:49 GMT

Can you check it once?

https://community.qlik.com/t5/QlikView-Layout-Visualizations/How-to-make-single-field-bold/td-p/670067

Re: Text format on pivot table doesn't work

Surya — Fri, 26 Apr 2019 06:45:16 GMT

Hi,

where ever your are concatinate tables first you create flag on those tables

load ..

..,

con as 'flag'

from path;

like after

in pivot table calculated dimension expand that + symbol and goto text

and write = if(con = 'flag','')

try it once

Thanks & Regards

Surya

Re: Text format on pivot table doesn't work

gf — Fri, 26 Apr 2019 06:49:15 GMT

Thanks for your answer @shiveshsingh!
I tried all the solution provided in this thread but with no success.

Regards

Re: Text format on pivot table doesn't work

gf — Fri, 26 Apr 2019 06:54:02 GMT

Thanks @Surya

my load looks like

Ueberleitung:
LOAD LAND AS LAND,
FCO as FCO,
STICHTAG as STICHTAG,
UK as UK,
SK as SK,
ApplyMap('Subkategorie_Texte',UK & SK) as SUBKATEGORIE,
Num#(BETRAG_ABGRENZUNG,'#.###,##') as BETRAG_ABGRENZUNG,
Num#(BETRAG_BILANZBUCHUNG,'#.###,##') as BETRAG_BILANZBUCHUNG,
EE as BE,
KTO_S as KTO_S,
KTO_H as KTO_H,
TEXT as TEXT_Ue,
Num#(DIFFERENZ,'#.###,##') as DIFFERENZ,
Num#(VERAENDERUNG_DIFFERENZ,'#.###,##') as VERAENDERUNG_DIFFERENZ;
SQL Select.......;

Concatenate(Ueberleitung)

UeSummen:
LOAD LAND,
FCO,
STICHTAG,
UK,
'' as SK,
'Summe Kategorie: ' & UK as SUBKATEGORIE,
NUM#(SUM(Distinct BETRAG_ABGRENZUNG),'#.###,##')* -1 as BETRAG_ABGRENZUNG,
NUM#(SUM(Distinct BETRAG_BILANZBUCHUNG),'#.###,##') * -1 as BETRAG_BILANZBUCHUNG,
'' as BE,
'' as KTO_S,
'' as KTO_H,
'' as TEXT_Ue,
NUM#(SUM(Distinct DIFFERENZ),'#.###,##') as DIFFERENZ,
NUM#(SUM(Distinct VERAENDERUNG_DIFFERENZ),'#.###,##') as VERAENDERUNG_DIFFERENZ
Resident Ueberleitung
Group by LAND, FCO, STICHTAG, UK;

and in my table i want to display my SUMs where SUBKATEGORIE like 'Summe Kategorie: *' bold.

Re: Text format on pivot table doesn't work

shiveshsingh — Fri, 26 Apr 2019 06:58:26 GMT

Are you comparing with source data in SQL?

Re: Text format on pivot table doesn't work

Surya — Fri, 26 Apr 2019 07:03:17 GMT

in pivot table expression or dimension > text format = if(field name,'')

Re: Text format on pivot table doesn't work

Surya — Fri, 26 Apr 2019 07:04:06 GMT

in pivot table expression or dimension > text format = if(field name,'')

Re: Text format on pivot table doesn't work

gf — Fri, 26 Apr 2019 07:36:06 GMT

@Surya as you see i tried it this way but nothing happened.

Re: Text format on pivot table doesn't work

gf — Fri, 26 Apr 2019 07:41:12 GMT

@shiveshsingh no, not yet , but I will try it

Re: Text format on pivot table doesn't work

gf — Fri, 26 Apr 2019 07:53:42 GMT

or is it possible to format text to bold inLOAD?

Re: Text format on pivot table doesn't work

gf — Fri, 26 Apr 2019 09:34:36 GMT

i still could not find a solution for this problem... is it a bug or something?

Re: Text format on pivot table doesn't work

Surya — Sat, 27 Apr 2019 03:49:39 GMT

PFA

Re: Text format on pivot table doesn't work

gf — Mon, 29 Apr 2019 06:29:48 GMT

Still no changes....

Re: Text format on pivot table doesn't work

gf — Mon, 29 Apr 2019 09:19:12 GMT

I changed the diagram to straight table, know it works....
I don't know why but it works.