how to show break ups

[kunkumnaveen]

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

[kaushiknsolanki]

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

[MayilVahanan · Accepted solution]

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

[kunkumnaveen]

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

[avinashelite]

use Straight table that will give you more option to play

[MayilVahanan]

HI

Try with Straight or Pivot Table

[kunkumnaveen]

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

[kunkumnaveen]

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

[avinashelite]

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

[MayilVahanan]

HI

In that case, try like this

Add 3 dimension

Add 1 as Expression

And In Presentation, select 1 as check the Hide column