mathematical in to qlikview expression

[kunkumnaveen]

Hello guys ,

i trying to write a mathematical expression in to qlikview expression........

PLACE	SHIP	STATUS	QUANTITY	TM
Load Port	shipment1	01	30,000.00	9.20
Load Port	shipment2	01	30,000.00	9.10
Load Port	shipment3	01	40,000.00	9.25

what i am looking is this irrespective of SHIP field:

                                IN Mathematical Expression                                                    Qlikview Epression   

                                30000*9.20+30000*9.10+40000*9.25                    HOW TO WRITE HERE                                                      

                                  30000+30000+40000                                         SUM({<PLACE={'Load Port'},STATUS={1}>}TOTAL QUANTITY)

Thanks

naveen

[bohravanraj]

=sum(Quantity*TM) / sum({1<pass all Possible value on which Selection Should Change>}Total Quantity)

[avinashelite]

Yes it possible ....

create one more variable like vSelection  and based on the button click ..set the variable like if the user click's on the

Load Port text/button add action to set the vSelection  to Load port  .....

then in the Straight table add an expression like this sum({<PLACE={"=($(vSelection) "}>}1)

or

sum({<PLACE={"=($(=vSelection) "}>}1)

and hide the expression in the presentation tab

hope this helps you

[kunkumnaveen]

HI

what writing this expression :

=sum({<PLACE={'DISPATCH'},SHIP_STATUS={1}>}QTY_DAILY*TM)/sum({<PLACE={'DISPATCH'},SHIP_STATUS={1}>} TOTAL QTY_DAILY)

i am getting value like this in a textbox

                                               10.4567387776

any how it is correct one ,is it possible to display only two digits after the decimal point

                                              10.45......enough

in straight table we have number option ,but in TEXT BOX i dont see any number .....