I have an issue with the straight table as i want to have only amount when DimName is 1 and Quantity when DimName is 2.Attaching the sample doc.
Please find attachment for solution...if you want to learn something more than it ..see whats new in qlikview 11 application ,in that see reports tab ,u'll come to know that ...:)
I had to put both quantity and amount into one expression.
Have a look at the attachment
Definition of expression:
if (DimNo=1, SUM(AMOUNT), if (DimNo=2, SUM (Quantity), ''))