change variable value according to %dim select

[gidon500]

Hi guys

I have file with PARTS  ,

For each part  there are price levels from A to D

I need to select price  for the PART according to the selection of the Pricelevel

Enclosed is a sample of Qlik doc , that includes PARTS and price levels

I need to create  an object with

PART,QUANTITY,UNIT PRICE

example:

p300,100,60  ( if price level is B )

thanks  for your help

gidon