Qlikview Expressions

[sannidhikumar]

Hi All,

Is it possible to create Qlikview expressions without aggregations.

Because I have value like

A   B

a   2

a  3

b  5

When I am using A as dimension and exp as sum(B) I am getting only 2 results in straight table, instead i need 3 results as it is.

By using dimension I am getting performance issues.Can you please suggest how to handle this.

Thanks

[avinashelite]

Try like this

Temp:

load * inline

[

A,B

a,2

a,3

b,5

];

Result:

noconcatenate

LOAD

A,

B,

rowno() as Key

resident

Temp;

Drop table Temp;

//add the key filed in the straight table and hide it from the Presentation tab..

this will give you the result

[sunny_talwar]

use table box object if you don't want to do any aggregation. Only thing to note is that table box shows the unique combination of fields that are being displayed. Anything which is getting double, tripple, and so on counted will be shown only once

[annafuksa1]

try function only()

=only(A)

and as expression use B.

or use table box

Anna