Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Help needed On expression

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 ]) ),

               or

        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

1 Solution

Accepted Solutions
SunilChauhan
Esteemed Contributor

Help needed On expression

use

Column (1) / Column (2)  inplace of 

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

9 Replies
Partner
Partner

Help needed On expression

Instead of using this expre..

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

Use

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

Not applicable

Help needed On expression

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

SunilChauhan
Esteemed Contributor

Help needed On expression

use

Column (1) / Column (2)  inplace of 

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

Not applicable

Help needed On expression

hi, Sunil thanks It is working

Please tell me about my II problem too.

thanks & regards

SunilChauhan
Esteemed Contributor

Help needed On expression

In expression you can

write

=Rowno()

hope this helps

Not applicable

Help needed On expression

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

SunilChauhan
Esteemed Contributor

Help needed On expression

sorry i cant understand

can come again with  more clear requirement?

Partner
Partner

Help needed On expression

You can use :

=Rowno()

Like Sunil Chauhan suggested.

And use Full Accumulation on the Expression tab.

Not applicable

Help needed On expression

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