I am trying to create a user changeable discount entry inside of a chart (set as a straight line table type) so that the Disc % on each line item can be assigned a different discount on the fly. A picture is below:
I have an external field called "Percent" that currently is set to 8% so the column called "Disc %" is reading that input field. When I change it to 15% all lines change to 15%. What I really want to do is set the first line (bn = ATORVASTATIN CALCIUM) to 65% and the second line (bn = LIPITOR) to 15%.
I am currently using Qlikview Version 10.00
Any help would be GREATLY appreciated!!
Steve