Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,i am trying to show breaksup of diff PLACE
scenario....
I tookthree diff text box:: Load Port Discharge Plant
100000 1000 3000
where ever user click on Load Port he should see load port breakups on diff tab(SHIP,QUANTITY),
IF user click on Discharge he should see Discharge breakups on diff tab(SHIP,QUANTITY),
IF user click on Plant he should see Plant breakups on diff tab(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 known how to write trigger to move from one tab to other...but the problem how to make qlikview to under which PLACE text box did user click and show the PLACE relevant SHIP AND QUANTITY
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
Hope that will help you
HI
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 .....
use num() function
Try like this
=num(sum({<PLACE={'DISPATCH'},SHIP_STATUS={1}>}QTY_DAILY*TM)/sum({<PLACE={'DISPATCH'},SHIP_STATUS={1}>} TOTAL QTY_DAILY),'#,##0.00')
Hi
Try like this
=Num(sum({<PLACE={'DISPATCH'},SHIP_STATUS={1}>}QTY_DAILY*TM)/sum({<PLACE={'DISPATCH'},SHIP_STATUS={1}>} TOTAL QTY_DAILY), '#,##0.##')