topic Help needed On expression in QlikView

Help needed On expression

Tue, 15 Nov 2011 06:52:36 GMT

Dear all,

I have 2 problem

1. I want create a expression based on other expression, just for a shake suppose I have 2 expressions in a straight table

a. sum( field 1) --- Column Name ----- Column 1

b. sum( filed 2) * sum( field 3 ) --- Column Name ----- Column 2

now I want to use both expressions in a other expression

c sum ( ( [ Column 1] / [ Column 2 ]) ),

sum([Column 1]) but it is given error bad field name [ Column 1 ] and [ Column 2]

2. I want running Row Nos. in a straight table

thanks & regards

Help needed On expression

jagannalla — Tue, 15 Nov 2011 06:56:22 GMT

Instead of using this expre..

sum ( ( [ Column 1] / [ Column 2 ]) ),

Use

= sum( field 1) /(sum( filed 2) * sum( field 3 ))

Help needed On expression

Tue, 15 Nov 2011 07:08:17 GMT

hi, Jagan

thanks for quick reply,

there is a huge formulation in the expression of [ Column 1 ] & [ Column 2 ] it is my requirement that new expression is based on other 2 expression, so I cant use field in my desired Expression

Help needed On expression

SunilChauhan — Tue, 15 Nov 2011 07:09:02 GMT

use

Column (1) / Column (2) inplace of

sum ( ( [ Column 1] / [ Column 2 ]) )

Help needed On expression

Tue, 15 Nov 2011 07:14:38 GMT

hi, Sunil thanks It is working

Please tell me about my II problem too.

thanks & regards

Help needed On expression

SunilChauhan — Tue, 15 Nov 2011 07:27:31 GMT

In expression you can

write

=Rowno()

hope this helps

Help needed On expression

Tue, 15 Nov 2011 07:34:33 GMT

hi, Sunil

yes, It is given me the actual row nos. but I want running Row Nos ( counter ).

Suppose in straight table after filter 6 row is coming then i want row nos like 1,2,3,4,5,6

and after another filter there is only 3 row then result should 1,2,3

thanks & regards

Help needed On expression

SunilChauhan — Tue, 15 Nov 2011 07:37:40 GMT

sorry i cant understand

can come again with more clear requirement?

Help needed On expression

Anonymous — Tue, 15 Nov 2011 08:10:29 GMT

You can use :

=Rowno()

Like Sunil Chauhan suggested.

And use Full Accumulation on the Expression tab.

Help needed On expression

Tue, 15 Nov 2011 09:58:38 GMT

I just want to serials the rows in straight table if there is 6 row in straight table then I want to serials them 1,2,3,4,5,6, if there is 4 rows then I want to serials them 1,2,3,4 means I just want to add a SNO. column in straight table.

I my opinion there is no need of rowno() function because it will return the serial no of loading time, I want to set serial no on straight tables's appearing record.

thanks & regards