Issue with a pivot table

[ferha_jafri]

Hello Everyone,

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.

[ferha_jafri]

Plz reply it is urgent

[#3]

Add expression Amount with conditional DimName =1

Add expression Quantity with conditional DimName = 2

[preminqlik]

hi feeha,

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 ...:)

regards

Premhas

[ferha_jafri]

Hi Erik

Thanks for your reply but  can you please attach a sample application...

[#6]

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), ''))