topic Re: Bold formatting in table chart in QlikView

Bold formatting in table chart

Wed, 22 Oct 2014 11:15:13 GMT

I want to make some of the rows bold in my table. I started with one of the dimensions and clicked Text Format and entered my condition:

=if(LINETYPE='HEADER' or LINETYPE='SUM', '')

But only the rows with LINETYPE=SUM shows in bold. I can't understand why this is.

Re: Bold formatting in table chart

anbu1984 — Wed, 22 Oct 2014 11:22:00 GMT

May be because of spaces

=if(Trim(LINETYPE)='HEADER' or LINETYPE='SUM', '')

Re: Bold formatting in table chart

Wed, 22 Oct 2014 11:26:10 GMT

Still no change

Re: Bold formatting in table chart

its_anandrjs — Wed, 22 Oct 2014 11:29:50 GMT

Try this also

=if(Match( LINETYPE, 'HEADER','SUM') , '')

Re: Bold formatting in table chart

anbu1984 — Wed, 22 Oct 2014 11:34:54 GMT

Is your data (LINETYPE='HEADER') is in upper case?

Try this

=if(Index(LINETYPE,'HEADER') or LINETYPE='SUM', '')

Re: Bold formatting in table chart

Wed, 22 Oct 2014 11:40:32 GMT

None of these seem to work. At first i thought it was because these lines have the value 0 in the expression so I created another expression which gave a value other than 0. But that didn't help.

Re: Bold formatting in table chart

ashfaq_haseeb — Wed, 22 Oct 2014 11:42:30 GMT

Hi,

Can you post sample app to look over?

Regards

ASHFAQ

Re: Bold formatting in table chart

Wed, 22 Oct 2014 11:44:37 GMT

there's a lot of company sensitive data so I can't. I'm sorry.

Re: Bold formatting in table chart

its_anandrjs — Wed, 22 Oct 2014 11:46:33 GMT

If possible any sort line sample test data is Ok to find out the problem you can change names and hide any sensitive data from others.

Regards

Anand

Re: Bold formatting in table chart

ashfaq_haseeb — Wed, 22 Oct 2014 11:49:17 GMT

Check this

Preparing examples for Upload - Reduction and Data Scrambling

Regards

ASHFAQ

Re: Bold formatting in table chart

PrashantSangle — Wed, 22 Oct 2014 11:51:15 GMT

Hi,

Try with wildmatch()

if(wildmatch(LINETYPE,'*HEADER*','*SUM*', '')

Regards

Re: Bold formatting in table chart

Wed, 22 Oct 2014 12:17:43 GMT

I have now taken out all sensitive and unnecessary data and I have entered fictionary amounts. Sorry about the texts being in swedish. What I have tried to do is an Income Statement. I got the idea from an example here on the forum except I also wanted headers and I wanted som space in between the account groups.

Re: Bold formatting in table chart

PrashantSangle — Wed, 22 Oct 2014 12:25:38 GMT

Hi,

write this expression

if(wildmatch(LINETYPE,'HEADER*','SUM*'), '')

it is working .

Since you made selection Aug But For Aug there is no data for Header There fore it is not showing in bold.

Regards

Re: Bold formatting in table chart

maternmi — Wed, 22 Oct 2014 12:27:52 GMT

Hi ,

please find attached the your example. I modified it and it works now.

BR. Michael

Re: Bold formatting in table chart

Wed, 22 Oct 2014 12:46:07 GMT

Yes, but if I select a year or a month it stops working. I have used set analysis on the other expression (showing line number) so that these rows even show at all. Is this what is causing the problem?

Re: Bold formatting in table chart

stigchel — Wed, 22 Oct 2014 13:13:19 GMT

Yes it is, try

=if(Match(Only( {< YEAR=, MONTH= >} LINETYPE), 'HEADER','SUM') , '')

Re: Bold formatting in table chart

Wed, 22 Oct 2014 13:20:27 GMT

That works perfectly. Thank you so much.

Re: Bold formatting in table chart

stigchel — Wed, 22 Oct 2014 13:23:17 GMT

You're welcome...