I have the following data in my table:
In this table, products sold together have the same Script Number (First Column in table). I want to be able to select a product name from a list box filter to identify all products sold together with the selected product. Say for example i select product name "NIZORAL(KETOCONAZOLE) I want to be able to list other products sold on the same Script Number which is '41' namely GRESEOFULVIN 125mg/5ml SUSP and FLUCLOXACILLIN 125MG/5ML. How can i accomplish this in QlikView?
Thanking you in advance.
Many thanks it certainly helps. However, you can have the same 'Product Name' appearing in another prescription. I am getting the following from some 2 million records or so:
This now gives multiple prescriptions instead of confining to one only. Is there a way out of this?