topic Re: Expression problem...!!! in QlikView

Expression problem...!!!

Fri, 07 Nov 2014 15:04:48 GMT

Dear All,

My basic expression is as follows.

ROUND(RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM))

The above formula was modified as follows to show only the negative values in the pivot table.

ROUND(ONLY({<RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM))={<"0"}>}RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM))

But the formula has a error in itself. Please help to find the correct formula(expression)

Regards,

Priyantha.

Fri, 07 Nov 2014 15:39:47 GMT

Try this

i have added field (columnname) and created a variable (RANGESUM=RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM)=0)

ROUND(ONLY({<FIELD={"$(RANGESUM)"}>}RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM)))

check if it helps

Sat, 08 Nov 2014 05:36:14 GMT

Dear Pooja,

Even your expression shows as "expression ok" , expected result not achieved,

Regards,

Priyantha.

maxgro — Sat, 08 Nov 2014 08:33:20 GMT

maybe

if (

RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM) <0,

RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM)

)

Sat, 08 Nov 2014 21:31:13 GMT

Dear Priyantha,

if possible could you provide some sample data and expect result

MarcoWedel — Sun, 16 Nov 2014 21:15:59 GMT

RangeMin(ROUND(RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM)),0)

and maybe check "suppress zero values" in your chart.

hope this helps

regards

Marco

Mon, 17 Nov 2014 06:16:17 GMT

Try with this

if (

RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM) <0,

RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM)

)