Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Error label in qlikview chart

Hi,

I'm new to qlikview. Can anybody please explain me how to display error label in qlikview charts??

I have a bar chart which needs to be displayed when user selects a value from listbox and it has to display error message when nothing or more than 1 item are selected.

Tags (4)
1 Solution

Accepted Solutions
quentin_bruno
Contributor

Re: Error label in qlikview chart

Hi,

What you can do if you want to have an error message and setting the "Always one selected value" as Salto explained to you, is to go in your chart properties. Inside the properties in General tab, you have a field "Calculation Condition" where you can write:


GetPossibleCount([ListboxDimension])=1

Then, click on the button "Error Messages", next on "calculation condition unfulfilled" and write below your error message.

Hope this helps.

Quentin

9 Replies
salto
Valued Contributor II

Re: Error label in qlikview chart

In this case, you can try setting the "Always one selected value" in the listbox.

In the listbox, first select a value and then go to  -> General -> Always one selected value.

Hope this helps!

Not applicable

Re: Error label in qlikview chart

Hi Salto,

Thanks for the reply.

"Always one selected value" option is disabled in my case.

And also along with this option I need to display proper error message on chart when user does not select anything.

salto
Valued Contributor II

Re: Error label in qlikview chart

Hello,

you need to select a value in the listbox, then the optoin is enabled. please try and let me know.

Not applicable

Re: Error label in qlikview chart

Thank you it worked for me ?Now I have to find a way to display error message on chart when user does not select anything.

salto
Valued Contributor II

Re: Error label in qlikview chart

Once you enable the "Always one selected value" option, there will  always be a selection made, so no error message is needed - no errors will occur!

Not applicable

Re: Error label in qlikview chart

Oops your are right. But my requirement is that all selections must go when user clicks on clear all. Because there are 2 list boxes on which the graph contents depend. User can select values from either of them. So there s possibility that user can select a value from one list box and leave the other. This requirement wont be met if I use "Always one selected value" option.

Re: Error label in qlikview chart

Kavitaladi

Salto is correct that it will force only value to be allowed.

But for future reference for an error message you could use an expression like this in a Text box

     =  if ( getselectedcount ( [YourDimension] ) = 1 , 'One Value selected' , 'Must only select one value' )

On the Text box you could use a similar type of expression on the Layout tab, under Show | Conditional to hid the text box when no error message need to be shown.

Best Regards,     Bill

quentin_bruno
Contributor

Re: Error label in qlikview chart

Hi,

What you can do if you want to have an error message and setting the "Always one selected value" as Salto explained to you, is to go in your chart properties. Inside the properties in General tab, you have a field "Calculation Condition" where you can write:


GetPossibleCount([ListboxDimension])=1

Then, click on the button "Error Messages", next on "calculation condition unfulfilled" and write below your error message.

Hope this helps.

Quentin

Not applicable

Re: Error label in qlikview chart

Hi Quentin,

This this exactly what i wanted  

Thanks a lot

Community Browser