topic Re: Cyclic chart has to display text object when make selection from cyclic group in QlikView

Cyclic chart has to display text object when make selection from cyclic group

Wed, 25 Nov 2020 16:16:04 GMT

Dear Experties ,

I need your all advises on the following requirements,as per cyclic chart selection the text box has to show company name or hide the text object this has to happen when i select any of the cyclic chart field from bar chart .Please refer the attached sample application for your testing .

Regards,

Sunny

Re: Cyclic chart has to display text object when make selection from cyclic group

sunny_talwar — Mon, 26 Jun 2017 14:42:47 GMT

Not sure if your requirement is clear. Are you saying if you are on CompanyName within your cycle group and then you select a single company, only then the text box object should show up? It won't show up if you are in another field on the cycle group and you select a company name?

Re: Cyclic chart has to display text object when make selection from cyclic group

Mon, 26 Jun 2017 14:48:02 GMT

Hi Sunny ,

Yes My Compnay name in the cycli group and have to show only compnay name in the text object or else it has to hide when we are do clear right ,now what i want i need to select any one of the variable from barcchart so text box need to display company name . cyclic varaible could be compnayname or name or regoins...etc.

Re: Cyclic chart has to display text object when make selection from cyclic group

sunny_talwar — Mon, 26 Jun 2017 15:00:26 GMT

Yes My Compnay name in the cycli group and have to show only compnay name in the text object or else it has to hide when we are do clear right ,now what i want i need to select any one of the variable from barcchart so text box need to display company name . cyclic varaible could be compnayname or name or regoins...etc.

Not sure I follow. It show only company name in the text object or else it has to hide... what does the cycle group has to do with any of this? You are selecting in the table and cycle group can be on anything, right?

Re: Cyclic chart has to display text object when make selection from cyclic group

Mon, 26 Jun 2017 15:11:07 GMT

let me explain you clearly for example i have bar chart with cyclic group ( name ,compnay name,regions...etc). when i am selecting company name from barchart cyclic text object displaying compnay name if i clear it text object hide. if i want to select anything(name or company name ,sub region---etc) from cyclic group text object need to display compnay name .

i tried like the this i have taken company name in the text object and layout expression : count (disntict compnayname)=1 ,this is giving for me compnay name when i select company name from cyclic bar chart the same way if i select others variables text object display compnay name .I hope this time you get it what i need .

Re: Cyclic chart has to display text object when make selection from cyclic group

vishsaggi — Mon, 26 Jun 2017 15:40:10 GMT

Is this what you are looking? Check attached.

Re: Cyclic chart has to display text object when make selection from cyclic group

Tue, 27 Jun 2017 08:33:33 GMT

Hi Nagaraju,

Thank you for the logic.Your logic should work my requirement but i have a one question here cant we show only one name rather than mutiple names in the text object

Re: Cyclic chart has to display text object when make selection from cyclic group

Tue, 27 Jun 2017 09:38:28 GMT

are you looking for seperate text object for each company name?

Re: Cyclic chart has to display text object when make selection from cyclic group

Tue, 27 Jun 2017 10:04:08 GMT

Hi ,

it is in single text object to display the company names

Re: Cyclic chart has to display text object when make selection from cyclic group

Tue, 27 Jun 2017 11:48:20 GMT

hi Sunni,

check the attachment, if you are looking for same. the text object will be visible only if possible count of country name is one.

i have modified Nagaraju file only.

Re: Cyclic chart has to display text object when make selection from cyclic group

vishsaggi — Tue, 27 Jun 2017 12:56:33 GMT

Based on my attached file, can you elaborate a little like what one name should be displayed when selected?