Wondering if anyone had a great solution for extrapolating data into blank cells from a table within Excel? I know what the data should be in those blank cells (please see example below) but the user has not filled them in. In the example below you can see that the customer has a contract for 3 systems. It is the same customer across the three rows and the same system with a different ID for two rows. How can I get Qlikview to populate the customer name and link it to those systems for a count?
I am a very new user to Qlikview so any advice would be greatly appreciated! Thanks in Advance.