topic Re: Chart Deatch in QlikView

Chart Detach

Fri, 13 Dec 2013 15:52:01 GMT

Hi Guys,

This is my first post and i hope i get a positive response on my query. I have 2 charts in the same tab and want to keep the first chart detached which works perfectly. However, when i save and close the file and then again open the file the chart doesnt seem to eb detached and i have to deatch it again.

Is there any way that the chart stays in the detached more even post reopening the qwd file?

Your assistance on this would be apprecaited.

Regards,

Yousuf

Re: Chart Deatch

Gysbert_Wassenaar — Fri, 13 Dec 2013 16:00:44 GMT

If you're using QV11 you can use alternate states. Create a new alternate state on the General tab of the document properties window and then assign the new alternate state to the chart on the General tab of the charts properties window.

Re: Chart Deatch

Fri, 13 Dec 2013 16:17:28 GMT

Thanks for the prompt reply. I believe alterantae states is for comapring 2 charts. I have a different requirement here.

May be some more deatils from my side would be helpful.

I have 2 charts. The top charts represents Regions (ASIA, EMEA,NAM & LATAM) and teh bottom chart represents countries.

I want that when i click on for eg: Asia on the first chat, its corresponding countries to be populated on the second chart which is currently happening. But teh probelm is that post clicking on Asia, i see only one bar for ASIA which i dont want. I want all 4 regions to be shown on the first chart which is achieved when i detach the first chart. I click on Asia, I still see all 4 regions on first chart and the corresponding countries for the second chart only for ASIA.

But teh problem is that once i repoen the file, the detach option is gone. I dont want my client to manually click on the detach option everytime. Is there any fix for this.

Thanks a ton for your assistance.

Re: Chart Deatch

Anonymous — Fri, 13 Dec 2013 16:32:21 GMT

Hai Yousuf,

did you try using set analysis on the first chart?

ex:

Dimension = Regions

Expression = Count({$<Regions=>}countries)

by doing that method it should ignore the selection of Chart 1 while we click on ASIA, EMEA, ETC.

Regards,

Re: Re: Chart Deatch

Gysbert_Wassenaar — Fri, 13 Dec 2013 16:38:57 GMT

See attached example.

Re: Chart Detach

Fri, 13 Dec 2013 16:56:39 GMT

Thanks again for your prompt reply. I am unable to open the file as i dont have the licenced version. My friend who has licence version left for home. I will check this tomorow. i just hope my problem gets resolved as i need to deliver this to my client by monday.

Thanks a ton for your help.

Re: Chart Detach

Fri, 13 Dec 2013 16:58:00 GMT

Hi.

Thanks for youe response.

i am quite novice. Will try this now and get back to you with the findings.

Thanks for your assistance.

Re: Chart Deatch

Tue, 17 Dec 2013 17:23:28 GMT

Thanks....I did it using set analysis

Re: Chart Detach

Tue, 17 Dec 2013 17:47:30 GMT

Hi Gysbert Wassenaar,

Thanks again for your prompt reply. I am also unable to open this file, as i don't have the licenced version and i am using PE version. Please give the explanation with any example…

Re: Chart Deatch

Anonymous — Wed, 18 Dec 2013 01:44:41 GMT

Hi Yousuf,

So you already can get what you need?

in the expression set analysis you just need to give command to ignore the selection of dimension table.

Regards,

Re: Chart Detach

Anonymous — Mon, 09 Nov 2015 21:40:44 GMT

after assigning the new alternate still the chart remains detached after saving .. is this a bug ?