topic Re: Pivot Table Display Problem in QlikView

Pivot Table Display Problem

anthony_kinsell — Fri, 25 Oct 2013 12:15:31 GMT

Hi,

I'm relatively new to Qlikview & am having sporadic issues using a pivot table. When I try collapse some rows the icon changes from - to + but the data remains visable.

What causes this to happen & how can it be corrected?

Re: Pivot Table Display Problem

Fri, 25 Oct 2013 12:18:01 GMT

Hi Anthony,

I'd first look at the table as a straight table and check what the expanded value should show (just to check it isn't null) - though even then it should show '-'.

Also, does it just happen to one row, or when it happens it affects all of the secondary column?

Kind Regards,

Dave

Re: Pivot Table Display Problem

anthony_kinsell — Fri, 25 Oct 2013 12:25:35 GMT

Hi Dave,

Ok – how can I get you this info?

Anthony

Re: Pivot Table Display Problem

Fri, 25 Oct 2013 12:31:43 GMT

If you select your pivot table and right click, then open the properties.

On the general tab, just select the straight table option (see image) (this won't affect your underlying table at all - you can just repeat this process back to make it a pivot table).

Re: Pivot Table Display Problem

anthony_kinsell — Fri, 25 Oct 2013 12:41:11 GMT

Sorry – misunderstanding there.

I know how to change the table to a straight, my question was how can I let you see this?

Re: Pivot Table Display Problem

Fri, 25 Oct 2013 12:46:17 GMT

Sorry, my bad, just check the data yourself and let me know (is simpliest) if the data is sensitive.

Otherwise you could export to excel or csv and attach or take a screenshot.

Re: Pivot Table Display Problem

MayilVahanan — Fri, 25 Oct 2013 12:49:13 GMT

Please copy and paste that chart, and check still tat issues occurs in pivot table?

Re: Pivot Table Display Problem

anthony_kinsell — Fri, 25 Oct 2013 13:10:00 GMT

It’s not overly sensitive.

I have changed the name of the property – the only sensitive part – see attached.

Anthony Kinsella

Financial Accountant

[cid:image002.png@01CED18C.035CC0C0]

Second Floor, Garryard House, Earlsfort Terrace, Dublin 2

Tel + 353 (1) 4161300

Direct: + 353 (1) 4161306

www.mcgarrellreilly.ie

DISCLAIMER. This email, and any files transmitted with it, is strictly confidential and intended solely for the person or organisation to whom it is addressed. If it comes to the attention of any other unauthorised person, no action may be taken on it nor should it be copied or shown to any third party. While this email has been swept for the presence of computer viruses, it is your responsibility to scan this email and any attachments for viruses. If you have received this email in error please return it to the sender and delete the email from your system.

P Before printing, think about the environment

Re: Pivot Table Display Problem

MayilVahanan — Fri, 25 Oct 2013 13:13:24 GMT

While exporting to excel, it takes all values and dimension in chart.

Re: Pivot Table Display Problem

anthony_kinsell — Fri, 25 Oct 2013 13:14:12 GMT

Also when I right-click on the pivot table I don’t get the expand all / collapse all options – don’t know if that will give an indication of what the issue is?

Re: Pivot Table Display Problem

MayilVahanan — Fri, 25 Oct 2013 14:13:52 GMT

Check in Presentation -> Always fully expanded is checked or not?, if checked, uncheck it.

Re: Pivot Table Display Problem

anthony_kinsell — Fri, 25 Oct 2013 14:20:48 GMT

Hi,

No it’s not checked – that’s what’s really odd about it, some of the rows do collapse as you’d expect & some don’t.

Re: Pivot Table Display Problem

MayilVahanan — Fri, 25 Oct 2013 14:21:59 GMT

Please create one another chart like tat.. and check it

Re: Pivot Table Display Problem

anthony_kinsell — Fri, 25 Oct 2013 14:26:12 GMT

I have numerous charts like this one – happened once on another one but seems to fix itself when I reloaded the data.

Hasn’t happened since until with this chart today

Re: Pivot Table Display Problem

anthony_kinsell — Fri, 25 Oct 2013 15:42:07 GMT

Figured out the answer.

When I right click on the pivot table & select 'Fit Columns to Data' I then get the option to collapse all which was previously greyed out.