Problem with combo chart

farheenayesha — Thu, 06 Mar 2014 14:39:56 GMT

Hi,

Can anyone help me to solve the problem displaying the proper values of discount % as line.

I have created a combo chart in which, Avg of order price are represented as bar and discount % as line.

I am getting proper values for avg of order price but i am getting 100%(straight line) for discount ,

Can anyone explain me why i am getting straight line and please suggest me how can i display proper discount %.

I want the graph as below:

Please find the values and formulas below for reference:

AOP=avg(ExtendedPrice)

vDiscount = (if(((sum(Order_List_Price)* sum(Orders_Quantity))-sum(ExtendedPrice))<0 or sum(ExtendedPrice)<0,0,(sum(Order_List_Price)* sum(Orders_Quantity))-sum(ExtendedPrice)))

Discount% = $(vDiscount) / Aggr((sum(Order_List_Price)*sum(Orders_Quantity)),O_BA_DESC)

topic Problem with combo chart in QlikView

Problem with combo chart