Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

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

1 Solution

Accepted Solutions

Re: how to show break ups

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

PLACESHIPSTATUSQUANTITY


14 Replies

Re: how to show break ups

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

Re: how to show break ups

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

PLACESHIPSTATUSQUANTITY


kunkumnaveen
Contributor III

Re: how to show break ups

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

Re: how to show break ups

use Straight table that will give you more option to play

Re: how to show break ups

HI

Try with Straight or Pivot Table

kunkumnaveen
Contributor III

Re: how to show break ups

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
Contributor III

Re: how to show break ups

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

Re: how to show break ups

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

Re: how to show break ups

HI

In that case, try like this

Add 3 dimension

Add 1 as Expression

And In Presentation, select 1 as check the Hide column

Community Browser