Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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!
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.
Hello,
you need to select a value in the listbox, then the optoin is enabled. please try and let me know.
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.
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!
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.
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
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
Hi Quentin,
This this exactly what i wanted
Thanks a lot