topic Re: Need a blank area before making selections for the chart in Qlik Learning Discussions

Need a blank area before making selections for the chart

Thu, 29 Jan 2015 08:14:16 GMT

Hello,

I want to make a chart out of the required selections only. But I'm getting a default chart even before the making a selection. How should I avoid this and get the chart only after making all the selections?

Thanks and Regards,

Arvind

Re: Need a blank area before making selections for the chart

morganaaron — Thu, 29 Jan 2015 09:21:02 GMT

Create a conditional show on the chart - on the layout tab, use a GetSelectedCount() function, add the field that you want to make selections on into the function and specify only when a certain amount of selections have been made, for example:

GetSelectedCount(Companies) > 0

That will only show the chart once a user makes a selection in the field companies, for example.

Re: Need a blank area before making selections for the chart

Thu, 29 Jan 2015 10:54:24 GMT

I will try that, Thank you Aaron.

Re: Need a blank area before making selections for the chart

Agis-Kalogiannis — Thu, 29 Jan 2015 11:12:13 GMT

You could modify the above function Arvind to refer to more fields

GetSelectedCount(Companies) > 0 AND GetSelectedCount(Country) > 0 AND ...

So the chart will show results only if you select all the necessary fields.

Regards

Agis

Re: Need a blank area before making selections for the chart

Thu, 29 Jan 2015 11:56:03 GMT

Great! Thank you Agis.

Re: Need a blank area before making selections for the chart

Agis-Kalogiannis — Thu, 29 Jan 2015 13:16:22 GMT

I am glad I could help.

Could you please mark the answers as Helpful or Correct so as to close the discussion?

I would appreciate it.

Thanks

Agis

Re: Need a blank area before making selections for the chart

Fri, 30 Jan 2015 06:26:43 GMT

Done, thanks again!

Regards,

Arvind