Discussion Board for collaboration on QlikView Scripting.
i got both negative and positive values in field how to distinguish them like positive,negative, Sum(positive and negative) .
give me some examples please.
Go to Solution.
Suppose this is your script:
load * inline [
Now create a bar charts with A as dimmenison and =fabs(sum(B)) as expression for negative values.
So in this way you can show both -ve and +ve values in two different bars.
You can create one more filed as "C" in script with positive numbers and check as Sum(c)
can you provide script please ,i haven't got lic here at the moment.
Simply add an expression sum(Your field). You can use a bar chart.
THANK YOU AMITH
and its Amit without ->"H"
Hi Use the
fabs() function in the expression