Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

9 Replies
salto
Specialist II
Specialist II

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
Author

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
Specialist II
Specialist II

Hello,

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

Not applicable
Author

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
Specialist II
Specialist II

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
Author

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.

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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
Author

Hi Quentin,

This this exactly what i wanted  

Thanks a lot