Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
manideep78
Partner - Specialist
Partner - Specialist

Background color change on Selection.... Urgent..!!!

Dear Community,

I have a Boxplot chart and 3 filters in mutlibox. When someone selects any value from any one of the fields of the multibox, then they should see different color boxes. and the user should select only one value from one filter at a time.

for example I have the image below:

Capture.JPG.jpg

I have filters in Multibox:

BC:1,2,3,4,5................

PW:1,2,3,4,5........

Line:A,B,C,D......

So when I select BC =1 the box plot color should change, again when I select BC = 2 a new color should come and the process goes on...

Again if PW=1 a new color will be seen.......

Again If Line=A a new color will be seen.....

Out of these 3 filters only one at a time should be selectable.

Please help

Thanks a ton in advance

Regards

Manideep

5 Replies
IamBack
Champion
Champion

write this in expression in calulated in attached image

if( getselectedcount(BC)>=1 or  getselectedcount(PW)>=1  getselectedcount(Line)>=1,Red(),Green())

Sunil Chauhan
mov
Employee
Employee

Apparently you need a conditional expression for the background color.  Just come up with the right conditions and colors.
A nuance for the box plot - use background color expression for the "Box Plot Top" only.

Regards,
Michael

manideep78
Partner - Specialist
Partner - Specialist
Author

Hi @SunilKumarChauhan,

There are more than 100 values for a single field. I need a different color for every value in the List box i selected. Can I write a generic expression that generate random color for every value in the list box?

manideep78
Partner - Specialist
Partner - Specialist
Author

Hi @MichaelSolomovich,

Yeah I need a conditional expression. But I can't write a condition like If or any other for a column with 100 values. I need a different color(any random color) for each and every value in the Column when I selected.

Thanks

Regards

Manideep

mov
Employee
Employee

You can try this expression and see if it makes sense.  It is a sort of random.  At least, it should react to selections:

=rgb(floor(rand()*256),floor(rand()*256),floor(rand()*256))

If it works, you may want to restrict the colors so you don't get too dark or too light.

Regards,
Michael