topic Detach chart will not save in QlikView

Detach chart will not save

Mon, 11 Feb 2013 22:02:33 GMT

How can I save a detached pivot table to save so that when I open the document at a later time the chart is saved? Thanks.

Or if someone could tell me how to fix my formula so that it will only select data within a specific 27 week period; 07/05/12-01/03/2013...this would be helpful, thanks!

=count({$<Plan = {'*Life*'}-{'*Paid Up*','*Select*'}, Type= {'Primary'}>} Distinct PresentationID)

Re: Detach chart will not save

Tue, 12 Feb 2013 07:09:19 GMT

How can I save a detached pivot table to save so that when I open the document at a later time the chart is saved?

You can create bookmark with all the selections and set macro on open loading Your bookmark and detach Your pivot

Or if someone could tell me how to fix my formula so that it will only select data within a specific 27 week period; 07/05/12-01/03/2013

Date={'>07/05/12<01/03/2013'}

Re: Detach chart will not save

sushil353 — Tue, 12 Feb 2013 07:26:06 GMT

=count({$<Plan = {'*Life*'}-{'*Paid Up*','*Select*'}, Type= {'Primary'}>} DistinctPresentationID)

modified

=count({$<Plan = {'*Life*'}-{'*Paid Up*','*Select*'}, Type= {'Primary'},Date={">07/05/12 <01/03/2013"}>} DistinctPresentationID)

where Date is your date field you can change the field name.

Re: Detach chart will not save

Tue, 12 Feb 2013 14:34:59 GMT

Thanks, I inserted the date formula