topic Re: Current Selection box, Text box, and a Chart in QlikView

Current Selection box, Text box, and a Chart

Fri, 17 Jan 2014 11:37:27 GMT

I am trying to display a message in my Chart when there are no items selected in the Current Selection Box. Can I create a text box that sits on top of my chart that states "Please select items" or another phrase only when the Current Selection box is empty or is there a better way?

David

Re: Current Selection box, Text box, and a Chart

sujeetsingh — Fri, 17 Jan 2014 11:45:06 GMT

David can you please explain in little detail

Re: Current Selection box, Text box, and a Chart

vikasmahajan — Fri, 17 Jan 2014 11:48:41 GMT

- Give the condition in GetSelectedCount( your field name )>0 in in calculation condition and set "error message" as Select <Field> to Generate the chart.

Hope this helps you pfa jpg attached.

vikas

Re: Current Selection box, Text box, and a Chart

Fri, 17 Jan 2014 11:53:20 GMT

Hi,

In this you can give Condition and error message

HTH

-Shruti

Re: Current Selection box, Text box, and a Chart

vikasmahajan — Fri, 17 Jan 2014 11:58:37 GMT

Thanks

Re: Current Selection box, Text box, and a Chart

Fri, 17 Jan 2014 12:28:01 GMT

Sorry about that. Not enough coffee on this Friday morning. Below you will see a screen shot of a prototype I am working on. You will see messages on the three charts. I want to change those messages to display something else only when they are no options showing in the current selection box. Does this make sense.

David

Re: Current Selection box, Text box, and a Chart

sebastiandperei — Fri, 17 Jan 2014 12:52:17 GMT

David, you could do:

1- Create a Text box, with your message, like "Please, make selections"

2- Give transparent background

3- Put it over the Current Selections Box, and give it a higher layer value. (Right button, order, bring to front)

4- Finally, in Properties of the text box, Layout, mark "Show Conditional", and put the following expression:

=IsNull(GetCurrentSelections())

This will show the text with your message only if you haven't made any selections.

Re: Current Selection box, Text box, and a Chart

Sat, 18 Jan 2014 02:03:41 GMT

Hi. This works perfectly for the Current Selection box. I need to do the same thing with the charts i create. If there are not selections I want a message.