topic Calculating Discount in QlikView

Calculating Discount

bharatkishore — Fri, 06 Jan 2012 06:58:04 GMT

Hello All,

I have an discount fields of 6 types Such as LD1,LD2,LD3,LD4,LD5,LD6.I have done all of them sum to get the total discount.Now i want to get only individiual discount.

And also i want to get all of the fields discount.Can any one help me.

Regards,

R.Bharat Kishore

Calculating Discount

vijay_iitkgp — Fri, 06 Jan 2012 07:02:25 GMT

Hi Bharat,

If I understand your question correctly. you can use if condition to create different fields.

If(Discount Type='LD1',DiscountAmount) AS LD1 and so on...

Hope this will help

Calculating Discount

bharatkishore — Fri, 06 Jan 2012 07:09:45 GMT

Hi Vijay,

Thanks a lot for the reply.But i already have six fields.I just want to get discount for each if them.Can you help me what expression i need to write.

Calculating Discount

vijay_iitkgp — Fri, 06 Jan 2012 07:12:55 GMT

then you can use Sales*LD1 as LD1Discount....