Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Highlighting

Hi,

I have a very simple question:

Is it possible to somehow turn of the automatic highlighting of Qlikview?

This question requires some explanation.

I have a simple Excel sheet with 3 rows: Customer, Representative, Year.

Customer = the name of a customer

Representative = the name of the sales rep that handles that customer

Year = the year in which the customer en sales rep were connected

Example:

Customer 1 is connected with Sales Rep A in the year 2009

I have 4 Listboxes:

1 for the year 2009

1 for the year 2010

1 for the year 2011

and 1 for the customers.

If I select a customer i want the listboxes to highlight the correct sales rep of that year.

I use the automatic highlighting of Qlikview.

But when I now select a Customer all salesreps that are connected to that customer get highlighted for all years.

I don't want that to happen. I just want Qlikview to highlight the correct sales rep in the correct year.

I thank anyone who responds to this discussion in advance.

Dries

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

not sure why you would like it in a list box like that but please see the attached example, I think that is what you are after?

hope this helps

thanks

Joe

View solution in original post

7 Replies
Not applicable
Author

can u please upload a snapshot of ur excel table.

Regards,

Shafvan

Not applicable
Author

snapshot.png

Here it is.

As you can see I only have three columns with limited data.

Not applicable
Author

are you able to upload your qvw, i'm a little unsure of exactly what you are trying to get for your end result

thanks

Joe

Not applicable
Author

Uploading the file will be impossible as I do not have the ownership rights but I can upload a snapshot.

snapshot2.png

As you can see I selected a Customer en would like Qlikview to highlight the correct sales reps in the listboxes to the left. The correct relationship between sales reps and customers can be found in the table to the right.

Not applicable
Author

As i am also very new to Qlikview, my knowledge is very limited.. I suggest you to have only three listboxes :

Customer, Representative & Year.

(But i may be wrong).

Regards

Shafvan

Not applicable
Author

Hi,

not sure why you would like it in a list box like that but please see the attached example, I think that is what you are after?

hope this helps

thanks

Joe

Not applicable
Author

That's just what I was looking for.

Thanks a lot.