topic Re: Pivot Table formatting help in QlikView

Pivot Table formatting help

Mon, 25 Jan 2016 17:04:48 GMT

Hi All,

Greetings for the day!

I have one requirement as i need to display pivot table in custom format as attached file.

I have tried with If conditions in Background color expression but result is not as expected.

I have tried with 'Custom Format Cell' option also and it's not worked.

Could you please anybody give me suggestion on this.

Thanks,

Vamsi

beck_bakytbek — Mon, 25 Jan 2016 17:26:58 GMT

Hi reddy,

look at this:

I hope that can solve your problem

Beck

Tue, 26 Jan 2016 05:50:38 GMT

Hi beck,

Thanks for your reply!

But is not the output as I am expecting. Could you please anybody have any idea please share with me here.

Thanks,

Chiru

tamilarasu — Tue, 26 Jan 2016 06:10:01 GMT

Did you check the below option in chart properties.!!

If this is not your expectation, check the below link,

jagan — Tue, 26 Jan 2016 06:19:02 GMT

HI,

It is not possible with Pivot Table, you can try with Straight Table. You can try this by using

Chart Properties -> Style -> Strips Every 1 Row option.

Hope this helps you.

Regards,

jagan.

Anonymous — Tue, 26 Jan 2016 10:05:11 GMT

Hi Reddy,

Here is a solution. By customizing the background color of the measure with the expression below, you will obtain the result you want.=>

=> IF(Even(RowNo(TOTAL)), rgb(240,240,240), rgb(0,174,255))

I've added an example in attachment.

Best regards.