topic Re: Chart Expression in QlikView

Chart Expression

Tue, 18 Dec 2012 12:38:27 GMT

Hiii,

I am uploading an excel sheet in which i want those only customer name in chart whose net collectable is greater than 2.

Please help me out.

sreenivas — Tue, 18 Dec 2012 12:50:11 GMT

In u r excel sheet all values are greater than 2 .... what values to be filtered

Tue, 18 Dec 2012 12:51:14 GMT

srry ...Value is greater than 3..

sreenivas — Tue, 18 Dec 2012 12:54:42 GMT

PFA

jagan — Wed, 19 Dec 2012 08:34:35 GMT

Hi,

Try this set analysis expression.

=sum({<Customer={'=Sum([Net Collectable]) > 3'}>}[Net Collectable])

Regards,

Jagan.

Wed, 19 Dec 2012 09:02:28 GMT

step 1- add pivote chart

step 2- take dimension Customer

step 3- add expression and write if([Net Collectable]>3,[Net Collectable])

hope this will help you

Wed, 19 Dec 2012 09:38:17 GMT

Hi,

You can do this in the script or in the Chart Expression

Script:

LOAD Customer,

[Net Collectable] as netCollectable

FROM

(biff, embedded labels, table is Sheet1$)

WHERE([Net Collectable] > 3);

Chart Expression:

=sum({<netCollectable = {">3"}>} netCollectable)

neha_shirsath — Wed, 19 Dec 2012 09:46:50 GMT

Hi,

you can try this.

if(Sum([Net Collectable])>3,([Net Collectable]))