topic Re: Highlighting in QlikView

Highlighting

Thu, 08 Sep 2011 07:37:48 GMT

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

Highlighting

Thu, 08 Sep 2011 08:21:40 GMT

can u please upload a snapshot of ur excel table.

Regards,

Shafvan

Re: Highlighting

Thu, 08 Sep 2011 08:28:22 GMT

Here it is.

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

Re: Highlighting

Thu, 08 Sep 2011 08:37:56 GMT

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

Re: Highlighting

Thu, 08 Sep 2011 08:50:03 GMT

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

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.

Highlighting

Thu, 08 Sep 2011 08:51:09 GMT

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

Re: Highlighting

Thu, 08 Sep 2011 09:13:38 GMT

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

Re: Highlighting

Thu, 08 Sep 2011 09:16:23 GMT

That's just what I was looking for.

Thanks a lot.