topic Re: Drawing a line in pivot table in QlikView

Drawing a line in pivot table

upaliwije — Tue, 01 Aug 2017 15:37:11 GMT

Hi,

I have following pivot table in my QV document

I want to draw a line shown above in red after total row. Is it possible if so pls tell me how to do it

Re: Drawing a line in pivot table

md_qlikview — Tue, 01 Aug 2017 15:42:09 GMT

How many dimension you are using?

And Try with > right click on chart>Custom format cell > set border after cell.

Re: Drawing a line in pivot table

Anonymous — Tue, 01 Aug 2017 15:42:26 GMT

Use custom Formatting :

Right click on any cell in pivot object ==> Custom Format Cell

formatting in pivot table....urgent | Qlik Community

Re: Drawing a line in pivot table

md_qlikview — Tue, 01 Aug 2017 15:46:09 GMT

Check the attached file for your reference.

Re: Drawing a line in pivot table

Anil_Babu_Samineni — Tue, 01 Aug 2017 15:47:31 GMT

Once upon a time i came to know and took the challenge, There is no straight forward. So then, I used Text object (But, My Pivot object is constant that time)

Re: Drawing a line in pivot table

upaliwije — Tue, 01 Aug 2017 15:56:50 GMT

Can you pls elaborate a little more

Re: Drawing a line in pivot table

upaliwije — Tue, 01 Aug 2017 15:59:54 GMT

Can you also tell me how to remove format already done

Re: Drawing a line in pivot table

md_qlikview — Tue, 01 Aug 2017 17:47:14 GMT

Go to Custom Format Cell by right clicking on your chart object then select 'Border after cell', you can change there your line style also. Please refer attached image.

If you are unable to see Custom Format Cell option on your qlikview file then first Go to> User Preferences> Design> at right bottom check Always Show design Menu items. After checking this Custom format cell option will get enable.