topic Re: mathematical in to qlikview expression in QlikView

mathematical in to qlikview expression

kunkumnaveen — Fri, 04 Mar 2016 06:56:50 GMT

Hello guys ,

i trying to write a mathematical expression in to qlikview expression........

PLACE	SHIP	STATUS	QUANTITY	TM
Load Port	shipment1	01	30,000.00	9.20
Load Port	shipment2	01	30,000.00	9.10
Load Port	shipment3	01	40,000.00	9.25

what i am looking is this irrespective of SHIP field:

IN Mathematical Expression Qlikview Epression

30000*9.20+30000*9.10+40000*9.25 HOW TO WRITE HERE

30000+30000+40000 SUM({<PLACE={'Load Port'},STATUS={1}>}TOTAL QUANTITY)

Thanks

naveen

Re: mathematical in to qlikview expression

kunkumnaveen — Fri, 04 Mar 2016 06:59:18 GMT

SORRY FOR THE ABOVE MESS EXPRESSION

IN Mathematical Expression Qlikview Epression

30000*9.20+30000*9.10+40000*9.25 HOW TO WRITE HERE

30000+30000+40000 SUM({<PLACE={'Load Port'},STATUS{1}>}TOTAL QUANTITY)

Re: mathematical in to qlikview expression

avinashelite — Fri, 04 Mar 2016 07:01:20 GMT

Try like this

SUM({<PLACE={'Load Port'},STATUS={01}>}QUANTITY*TM)/SUM({<PLACE={'Load Port'},STATUS={01}>}QUANTITY)

Re: mathematical in to qlikview expression

jonathandienst — Fri, 04 Mar 2016 07:03:07 GMT

Depends on the context. For a standalone version:

=Sum({<PLACE={'Load Port'}, STATUS={01}>} QUANTITY*TM)

/ Sum({<PLACE={'Load Port'}, STATUS={01}>} QUANTITY)

Re: mathematical in to qlikview expression

Anonymous — Fri, 04 Mar 2016 07:14:35 GMT

you may try this as well?

=sum(QUANTITY*TM) / sum(total QUANTITY)

Re: mathematical in to qlikview expression

kunkumnaveen — Fri, 04 Mar 2016 07:23:30 GMT

Hello Avinash,

thanks for your quick reply and correct answer.....i have one more query on that ,as i am showing sum of quantity irrespective of shipments in a textbox==100000..right

so my requirement is when the client click on that particular textbox ,he what to see the breakup in another tab.....

to move from one tab to another tab i known how to write trigger action.....but how to show break up...it doesn't matter whether we show in table or some other charts

output should be like this when clik on text box

	SHIP		QUANTITY
	shipment1		30,000.00
	shipment2		30,000.00
	shipment3		40,000.00

thanks

naveen

Re: mathematical in to qlikview expression

kunkumnaveen — Fri, 04 Mar 2016 07:24:02 GMT

Hello jonathan,

thanks for your quick reply and correct answer.....i have one more query on that ,as i am showing sum of quantity irrespective of shipments in a textbox==100000..right

so my requirement is when the client click on that particular textbox ,he what to see the breakup in another tab.....

to move from one tab to another tab i known how to write trigger action.....but how to show break up...it doesn't matter whether we show in table or some other charts

output should be like this when clik on text box

	SHIP		QUANTITY
	shipment1		30,000.00
	shipment2		30,000.00
	shipment3		40,000.00

thanks

naveen

Re: mathematical in to qlikview expression

avinashelite — Fri, 04 Mar 2016 07:30:22 GMT

Try like this :

1.Create a variable like vShow_shipment with value 0

2. In the text box add a action in the properties > and on the click set the variable to 1

3.Create a table box or straight table with the SHIP and QUANTITY as the fields ..

then go to chart properties > layout > conditional show> add the variable vShow_shipment

so when the user click on the text box it sets the variable to 1 so the chart will appear accordingly

4. To hide the chart you can add one more text box and set the action to set variable to 0

Or you may try the toggle button as well

Re: mathematical in to qlikview expression

avinashelite — Fri, 04 Mar 2016 07:39:46 GMT

For toggle button check this thread

Toggle Button | Qlik Community

Toggle Selection using a single button

Single button which toggles between two combinations of multiple field selections (and changes colour as it does so)?

Re: mathematical in to qlikview expression

kunkumnaveen — Fri, 04 Mar 2016 08:31:23 GMT

Hello Avinash

sorry for annoying you ,one last question the one u said above will it possible in this scenario....

three diff text box:: Load Port Discharge Plant

100000 1000 3000

where ever user click on Load Port he should see load port breakups(SHIP,QUANTITY),

IF user click on Discharge he should see Discharge breakups(SHIP,QUANTITY),

IF user click on Plant he should see Plant breakups(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 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

Re: mathematical in to qlikview expression

bohravanraj — Fri, 04 Mar 2016 08:40:51 GMT

=sum(Quantity*TM) / sum({1<pass all Possible value on which Selection Should Change>}Total Quantity)

Re: mathematical in to qlikview expression

avinashelite — Fri, 04 Mar 2016 10:05:40 GMT

Yes it possible ....

create one more variable like vSelection and based on the button click ..set the variable like if the user click's on the

Load Port text/button add action to set the vSelection to Load port .....

then in the Straight table add an expression like this sum({<PLACE={"=($(vSelection) "}>}1)

sum({<PLACE={"=($(=vSelection) "}>}1)

and hide the expression in the presentation tab

hope this helps you

Re: mathematical in to qlikview expression

kunkumnaveen — Fri, 04 Mar 2016 11:30:50 GMT

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