topic Re: Error message in Combo chart to restrict the user from selecting more than one value from one of the list box. in QlikView

Error message in Combo chart to restrict the user from selecting more than one value from one of the list box.

qlikviewforum — Wed, 17 Sep 2014 07:33:07 GMT

Hi,

In a combo chart I want to display the error message to the user if more than one value is selected from one of the list box. Please help to achive this

Re: Error message in Combo chart to restrict the user from selecting more than one value from one of the list box.

Yousef_Amarneh — Wed, 17 Sep 2014 07:38:26 GMT

go to General tab, click Error Message button and write your error message in the Custom Error Message text box, then in the General tab also there is a text box for Calculation Function, in there you can define your condition ex:

If(GetSelectedCount(FieldName)>1,0,1)

Re: Error message in Combo chart to restrict the user from selecting more than one value from one of the list box.

qlikviewforum — Wed, 17 Sep 2014 07:55:35 GMT

I did the same thing but it is not working. Please help!

Re: Error message in Combo chart to restrict the user from selecting more than one value from one of the list box.

Yousef_Amarneh — Wed, 17 Sep 2014 08:00:50 GMT

Share your application with me to try it, I tried it before and I am pretty sure that it works fine.

Re: Error message in Combo chart to restrict the user from selecting more than one value from one of the list box.

qlikviewforum — Wed, 17 Sep 2014 08:10:32 GMT

Sorry I cannot attach the application due to confidential/security reason. Can you please attach some sample work around if you can? That would be helpful

Re: Error message in Combo chart to restrict the user from selecting more than one value from one of the list box.

qlikviewforum — Wed, 17 Sep 2014 08:16:01 GMT

In the Combo chart, Layout tab --> Show --> I have already have condition called

FieldName='XYZ' or FieldName='ABC'

So the same fieldname whatever we have used as condition in Layout tab, the same has been used in the Calculation Condition in the General tab.

I think this is what causing the issue. Any idea how to overcome from this?

Re: Error message in Combo chart to restrict the user from selecting more than one value from one of the list box.

Yousef_Amarneh — Wed, 17 Sep 2014 08:20:50 GMT

Please find this sample, it works fine

Re: Re: Error message in Combo chart to restrict the user from selecting more than one value from one of the list box.

qlikviewforum — Wed, 17 Sep 2014 08:32:31 GMT

Please see the attached now it wont work as I have condition in the layout also as I mentioned in the above post.

Re: Re: Re: Error message in Combo chart to restrict the user from selecting more than one value from one of the list box.

Yousef_Amarneh — Wed, 17 Sep 2014 08:43:28 GMT

see this

Re: Error message in Combo chart to restrict the user from selecting more than one value from one of the list box.

Yousef_Amarneh — Wed, 17 Sep 2014 09:13:02 GMT

Please if this solution works with you please mark my answer as correct answer

Re: Error message in Combo chart to restrict the user from selecting more than one value from one of the list box.

Anonymous — Wed, 17 Sep 2014 09:27:22 GMT

Hi qlikviewforum,

find the attached qvw file. In this file in address field if you will select only one address then in chart it will show the chart value but when you will select more than one value then it will give the error msg.

thanks

Re: Error message in Combo chart to restrict the user from selecting more than one value from one of the list box.

qlikviewforum — Fri, 19 Sep 2014 07:31:07 GMT

Marked as correct answer please check