topic Expressions in QlikView

Expressions

Tue, 21 Dec 2010 17:43:46 GMT

hello,

i have chart with one expression and one dimension, i have 3 text objects and i want the total of the expression to come to that text object.

in the expression i put the following formula if((Type)='EXP',Sum (Potential)).

i want the total of the "POTENTIAL" to display in the text box.

AW:Expressions

brenner_martina — Tue, 21 Dec 2010 17:55:13 GMT

Hi,

possibly that:

Num(if(Type='EXP',Sum (Total Potential)),'#,##0')

AW:Expressions

Wed, 22 Dec 2010 06:28:01 GMT

Hi Martina,

thanks for the help its works perfectly, but actually i haven't given all the information.

This is the screen shoot TEXT OBJECT is A, B, C

what i want is object box A should have the same value as chart "Exports Amt", B holding the value from "Imports Amt" and C holding "X Trade Amt"

if list box "Exp" is selected then as per the chart expreesion formulas =If((Type)='EXP',Sum (Potential))

similarly for other 2 chart also.

the other two chart will be nill, and if noting selected in the list box all the chart box will have the respective value.

to summarise what i was look for is the value of CHART to TEXT OBJECT.

AW:Expressions

Wed, 22 Dec 2010 10:12:08 GMT

try

Sum ({$<Exim={$(=Exim)}>}Potential)

in the 3 cells and also in the textboxes.

AW:Expressions

Wed, 22 Dec 2010 10:57:17 GMT

Thank you Jochem,

The problem is that now I am getting 3 rows, in each chart, where as i require only one value. to get that in chart i put

"If((Type)='EXP',Sum (Potential))" in the chart1, "If((Type)='IMP',Sum (Potential))" in the chart2, and "If((Type)='X Trade',Sum (Potential))" in the chart3, doing like this i got one value.

i have added your formula in the expression and in the text object, text object is showing the cumulative value.

i will have 3 values in the text objects depending on the EXIM value.

I am new to this and still to understand the concepts.

AW:Expressions

Wed, 22 Dec 2010 13:47:56 GMT

Than you guys,

the problem was due to set anlysis. i got the below link in which John Witherspoon explain in detail.

http://community.qlik.com/forums/p/19888/93479.aspx

I put =Sum ({$<Type={'X Trade'}>}Potential)

In the text object and i got the result.