Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
gf
Contributor II

Text format on pivot table doesn't work

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','<B>') ) 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*'),'<I>') and this works perfectly.

Thanks in advance!

 

Regards 

Gf

1 Solution

Accepted Solutions
gf
Contributor II

Re: Text format on pivot table doesn't work

I changed the diagram to straight table, know it works....
I don't know why but it works.
14 Replies
shiveshsingh
Honored Contributor

Re: Text format on pivot table doesn't work

Surya
New Contributor III

Re: Text format on pivot table doesn't work

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','<B>')

 

try it once 

 

Thanks & Regards 

Surya 

 

gf
Contributor II

Re: Text format on pivot table doesn't work

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

Regards
gf
Contributor II

Re: Text format on pivot table doesn't work

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.

 

shiveshsingh
Honored Contributor

Re: Text format on pivot table doesn't work

Hi

Are you comparing with source data in SQL?

Surya
New Contributor III

Re: Text format on pivot table doesn't work

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

Surya
New Contributor III

Re: Text format on pivot table doesn't work

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

gf
Contributor II

Re: Text format on pivot table doesn't work

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

gf
Contributor II

Re: Text format on pivot table doesn't work

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