topic Re: Display text message in a chart from cyclical group selection in QlikView

Display text message in a chart from cyclical group selection

xarapre7 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to display just txt message when a specific cyclical group is selected from the chart.

But, the others from the cyclical group should still be displayed upon selection.

How should i go about this? Thank you in advance.

Re: Display text message in a chart from cyclical group selection

Anonymous — Tue, 09 Oct 2018 03:38:00 GMT

Hi ,

try this "=if(GrpCust="Skills",0,sum(Calls))"

Re: Display text message in a chart from cyclical group selection

felipedl — Tue, 09 Oct 2018 13:40:13 GMT

Hi,

Use the GetCurrentField() statement, like so:

=GetCurrentField(GrpCust)

This will get the current cyclic group field value and so you can make an if statement to get the appropriate message you want.

Re: Display text message in a chart from cyclical group selection

sudeepkm — Tue, 09 Oct 2018 14:11:01 GMT

you can apply a condition in your chart using the GetCurrentField() as suggested by Felip.

Then you can use custom error message to display the text you want to show when the Group is "Skills"

Please find the attached qvw.

What I want to know is if you do not want to show data in chart when the specific Field in a Group is selected then why do you want to add that Field in the Group itself.

Re: Display text message in a chart from cyclical group selection

xarapre7 — Tue, 09 Oct 2018 15:09:13 GMT

This group is being used in other charts in a container that's why it needs to be included in the cyclical group. I'll go ahead and try what you suggested. Thanks.