topic Re: Qlikview Expressions in QlikView

Qlikview Expressions

sannidhikumar — Tue, 10 Jan 2017 09:29:38 GMT

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

Re: Qlikview Expressions

avinashelite — Tue, 10 Jan 2017 09:36:30 GMT

Try like this

Temp:

load * inline

[

A,B

a,2

a,3

b,5

];

Result:

noconcatenate

LOAD

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

Re: Qlikview Expressions

sunny_talwar — Tue, 10 Jan 2017 10:22:17 GMT

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

Re: Qlikview Expressions

annafuksa1 — Tue, 10 Jan 2017 11:30:32 GMT

try function only()

=only(A)

and as expression use B.

or use table box

Anna