Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
possibly that:
Num(if(Type='EXP',Sum (Total Potential)),'#,##0')
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.
try
Sum ({$<Exim={$(=Exim)}>}Potential)
in the 3 cells and also in the textboxes.
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.
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.