Drawing a line in pivot table

[upaliwije]

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

[md_qlikview]

How many dimension you are using?

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

[Anonymous]

Use custom Formatting :

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

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

[md_qlikview · Accepted solution]

Check the attached file for your reference.

[Anil_Babu_Samineni]

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)

[upaliwije]

Can you pls elaborate a little more

[upaliwije]

Can you also tell me how to remove format already done

[md_qlikview]

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.