topic Re: Alternate States and Send To Excel-issue in QlikView

Alternate States and Send To Excel-issue

Mon, 21 Jul 2014 11:51:53 GMT

I have multiple linked copies of the same chart (table), but they show different values because of different inherited (alternate) states and selections. So far, so good, works like a charm.

When sending the chart to Excel however, the data sent is from the default state. I cannot find any documentation stating that this should be the case.

In the attached file, the charts CH01 and CH03 in sheet "State A" should show the same results (and they do), but they don't send the same data to excel, at least not for me

Anyone know why this is happening?

I know how to fix it (make new equal non-linked object), but in this case linked objects are preferred.

Re: Alternate States and Send To Excel-issue

avinashelite — Mon, 21 Jul 2014 12:18:48 GMT

Hi Andreas,

Since your using the same chart its Object ID is same in both the sheet due to Alternate state Qlikview will provide show the different representation but while exporting it will always refer the 1st state hence we get like this.

As per my knowledge we need to create a new object and use the same!!!!

Regards,

@vi

Re: Alternate States and Send To Excel-issue

Mon, 21 Jul 2014 13:04:57 GMT

Yes, that is what I found out. The questing is why?

I see noe reason why an object showing data from selection in state A should export according to the DEFAULT state. That is IMHO quite counter-intuitive.

This is either thought through by the developers but not documented (In which case I am looking for the explanation for this behaviour) or its just a bug waiting for SR8

Re: Alternate States and Send To Excel-issue

avinashelite — Mon, 21 Jul 2014 14:10:10 GMT

Hi Andreas,

I think its a Bug, if you get any update please let me know

Re: Alternate States and Send To Excel-issue

ashfaq_haseeb — Mon, 21 Jul 2014 14:14:49 GMT

Hi Strange it does not work.

Try to export to CSV instead, It worked for me.

It could be workaround until Qlik Fix it .

Right Clikck --> Export --> Select .csv extension.

Regards

ASHFAQ

Re: Alternate States and Send To Excel-issue

Tue, 22 Jul 2014 06:16:51 GMT

I'll send this as a bug to customersupport. If I hear anything from them, I will let you know

Re: Alternate States and Send To Excel-issue

Tue, 22 Jul 2014 07:03:53 GMT

Hi Andreas,

IF I understood your problem correctly then

No need to change the object ID instead go to the chart and assign the state on object.

For example in your application, go to StateA sheet and on CH01 object go to properties and change the state to StateA . Then your work is done and while exporting it works as expected. Same applies to other charts as well

Best Regards,

Avinash Jagilenki

Re: Alternate States and Send To Excel-issue

avinashelite — Tue, 22 Jul 2014 07:19:38 GMT

Hi,

Yes, for that sheet it will but what about the other sheet objects!!!!!

Its a linked object so it show same chart in all the sheets i.e according to the state u have set, not according to the

alternate state of that sheet

Regards,

@vi

Re: Alternate States and Send To Excel-issue

Tue, 22 Jul 2014 13:12:27 GMT

Missed the point at first instance