topic Re: Pivot table in QlikView

Pivot table

Anonymous — Wed, 05 Sep 2012 20:54:59 GMT

Hi,

I have list of iD (pivot table), where I show TOTAL and if field "TC" has data or no.

I wrote an expression. For some of them works, for other not.

I'd like to show, if empty cell -No (red and bold), if not empty-Yes (black and regular). It should ignore calendar.

Please see attached file.

Thanks,

Wed, 05 Sep 2012 21:24:38 GMT

Try:

Wed, 05 Sep 2012 21:31:31 GMT

Attached example.

Wed, 05 Sep 2012 21:35:19 GMT

Also, for the formatting, use:

Text Color: if(TC = 'No', rgb(255,0,0), rgb(0,0,0))

Text Format: if(TC = 'No', '<B>')

Anonymous — Thu, 06 Sep 2012 13:42:34 GMT

Thanks guys for your help.