topic Re: Expression help in QlikView

Expression help

Mon, 13 Oct 2014 02:53:07 GMT

Dear all,

My pivot table like this,

BCOD	CRE_CODE	REF_NO	PREMUM	BRO_COMM	BRO_ORC	AGE_COM	AGE_ORC	GRO_COM	GRO_ORC	DIRECT ME	TOT_COM	DIFF	TOTAL
BA00	C0003990	BA0014D0028258	53035	0	0	7289	0	0	0	0	4638		0
	C0005750	BA0014D0028454	27100	0	0	3735	0	0	0	0	2380		0
	C0008186	BA0014D0028343	15195	0	0	2024	0	0	0	0	1265		0
	C0008186	BA0014D0028484	53195	0	0	7549	0	0	0	0	4889		0
	DIR	BA0014D0028243	11773	0	0	1637	0	0	0	0	1048		0
	DIR	BA0014D0028344	16400	0	0	2185	0	0	0	0	1365		0
	6297	BA0014D0028454	27100	0	0	0	0	0	0	0	575		0
	54781	BA0014D0028455	6495	0	0	0	0	0	0	-1	625		0
	Total		183193	0	0	24419	0	0	0	0	16785		0

So I want to calculate "AGE_ORC" for the ME codes.

The expression i used there is shown below. Even the expression shows the status "OK" , relevant calculation not done.

sum({<Cat={'AG'},POSI={ME}>}(COM_PRE*AG_COM_ORC+SR*AG_RS_ORC+TC*AG_TC_ORC))/100

Please can any one help me in this regard, Early reply highly appreciated.

Priyantha.

Re: Expression help

jagan — Mon, 13 Oct 2014 03:43:12 GMT

Hi,

Try this expression

=sum({<Cat={'AG'},POSI={'ME'}>} (COM_PRE*AG_COM_ORC+SR*AG_RS_ORC+TC*AG_TC_ORC))/100

If not working attach sample file.

Regards,

Jagan.

Re: Expression help

Mon, 13 Oct 2014 04:05:50 GMT

Dear Jagan,

The same formula i have already applied (see the above post)

Re: Expression help

jagan — Mon, 13 Oct 2014 04:13:19 GMT

Hi,

It is difficult to give answer without sample file, your expressions seems to be correct, you really have values for this expression? Check this expression in Text object whether you are getting any value.

=sum( (COM_PRE*AG_COM_ORC+SR*AG_RS_ORC+TC*AG_TC_ORC))/100

If you are getting value then there is no records for Cat='AG', POSI='ME', if possible attach the file.

Regards,

Jagan.

Re: Expression help

Mon, 13 Oct 2014 04:17:07 GMT

Dear Priyantha ,

your question is not clear so elaborate the problem and give sample in excel.

Regards

Vimlesh Gupta