Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
can u please upload a snapshot of ur excel table.
Regards,
Shafvan
Here it is.
As you can see I only have three columns with limited data.
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
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.
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
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
That's just what I was looking for.
Thanks a lot.