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
Hi
Try like this
Textbox 1:
In text box, Action > Add -> Select in Field (From Selection Action Type)
Field : PLACE
Search in string: Load Port
Same thing, replicate for remaining 2 boxs
Create a chart with
PLACE | SHIP | STATUS | QUANTITY |
Hi,
Use the set analysis.
Something like this.
Assuming user has selected "Load Port" then
Only({<SHIP = {"Shipment 1"}>}SHIP)
Only({<SHIP = {"Shipment 1"}>}Quantity)
Only({<SHIP = {"Shipment 2"}>}SHIP)
Only({<SHIP = {"Shipment 2"}>}Quantity)
Only({<SHIP = {"Shipment 3"}>}SHIP)
Only({<SHIP = {"Shipment 3"}>}Quantity)
Regards,
Kaushik Solanki
Hi
Try like this
Textbox 1:
In text box, Action > Add -> Select in Field (From Selection Action Type)
Field : PLACE
Search in string: Load Port
Same thing, replicate for remaining 2 boxs
Create a chart with
PLACE | SHIP | STATUS | QUANTITY |
Hello Mayil,
excellent it work out ,one last request from you ,will u please help me in choosing the chart ,currently i am showing in table box,but dint look that great ,with your experience can you please suggest me a great looking chart.....
thanks
naveen
use Straight table that will give you more option to play
HI
Try with Straight or Pivot Table
Hi
Without expression only with dimension will straight table display the values .........i tried in putting three dimension without expression(which i dont need in this scenario),i am getting blank table...will it works without expression
Hi
Without expression only with dimension will straight table display the values .........i tried in putting three dimension without expression(which i dont need in this scenario),i am getting blank table...will it works without expression
No , you need add at-least 1 expression ...add a expression and hide the same > go to presentation tab> on the left had side you will see the expression and below you will have the option to hide > click on the hide option .
Now you will have only 3 dimension in the chart
hope this helps you
HI
In that case, try like this
Add 3 dimension
Add 1 as Expression
And In Presentation, select 1 as check the Hide column