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

[kunkumnaveen]

SORRY FOR THE ABOVE MESS EXPRESSION

  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)

[avinashelite · Accepted solution]

Try like this

SUM({<PLACE={'Load Port'},STATUS={01}>}QUANTITY*TM)/SUM({<PLACE={'Load Port'},STATUS={01}>}QUANTITY)

[jonathandienst]

Depends on the context. For a standalone version:

=Sum({<PLACE={'Load Port'}, STATUS={01}>} QUANTITY*TM)

/ Sum({<PLACE={'Load Port'}, STATUS={01}>} QUANTITY)

[Anonymous]

you may try this as well?

=sum(QUANTITY*TM) / sum(total QUANTITY)

[kunkumnaveen]

Hello Avinash,

thanks for your quick reply and correct answer.....i have one more query on that ,as i am showing sum of quantity irrespective of shipments in a textbox==100000..right

so my requirement is when the client click on that particular textbox ,he what to see the breakup in another tab.....

to move from one tab to another tab i known how to write trigger action.....but how to show break up...it doesn't matter whether we show in table or some other charts

output should be like this when clik on text box

	SHIP		QUANTITY
	shipment1		30,000.00
	shipment2		30,000.00
	shipment3		40,000.00

thanks

naveen

[kunkumnaveen]

Hello jonathan,

thanks for your quick reply and correct answer.....i have one more query on that ,as i am showing sum of quantity irrespective of shipments in a textbox==100000..right

so my requirement is when the client click on that particular textbox ,he what to see the breakup in another tab.....

to move from one tab to another tab i known how to write trigger action.....but how to show break up...it doesn't matter whether we show in table or some other charts

output should be like this when clik on text box

	SHIP		QUANTITY
	shipment1		30,000.00
	shipment2		30,000.00
	shipment3		40,000.00

thanks

naveen

[avinashelite]

Try like this :

1.Create a variable like vShow_shipment with value 0

2. In the text box add a action in the properties > and on the click set the variable to 1

3.Create a table box or straight table with the SHIP and QUANTITY as the fields ..

then go to chart properties > layout > conditional show> add the variable vShow_shipment

so when the user click on the text box it sets the variable to 1 so the chart will appear accordingly

4. To hide the chart you can add one more text box and set the action to set variable to 0

Or you may try the toggle button as well

[avinashelite]

For toggle button check this thread

Toggle Button | Qlik Community

Toggle Selection using a single button

Single button which toggles between two combinations of multiple field selections (and changes colou...

[kunkumnaveen]

Hello Avinash

sorry for annoying you ,one last question the one u said above will it possible in this scenario....

three diff text box::     Load Port                     Discharge                            Plant 

                             100000                               1000                                   3000

where ever user click on Load Port he should see load port breakups(SHIP,QUANTITY),

IF user click on Discharge he should see Discharge  breakups(SHIP,QUANTITY),

IF user click on Plant he should see Plant  breakups(SHIP,QUANTITY),

PLACE	SHIP	STATUS	QUANTITY
Load Port	shipment1	01	30,000.00
Load Port	shipment2	01	30,000.00
Load Port	shipment3	01	40,000.00

Discharge      shipment1              01                  100

Discharge      shipment4              01                  500

Discharge      shipment5              01                  400

Plant            shipment1              01                  1000

Plant            shipment4              01                  1000

Plant            shipment6             01                  1000

i think we need to write some expression and set diff variable values for each place .......is it possible to show all them in same table ....

thanks

naveen