Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

how to show break ups

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),

PLACESHIPSTATUSQUANTITY
Load Portshipment10130,000.00
Load Portshipment20130,000.00
Load Portshipment30140,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

14 Replies
MayilVahanan

Hope that will help you

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
kunkumnaveen
Specialist
Specialist
Author

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 .....

avinashelite

use num() function

avinashelite

Try like this

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

MayilVahanan

Hi

Try like this

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.