topic Re: urgent expression? in QlikView

urgent expression?

Tue, 11 Nov 2014 09:38:06 GMT

i have a AMOUNT FIELD, TYPE FIELD,

AMOUNT:

100

200

300

400

500

TYPE :

BIG

SMALL

HERE I WANT FIND OUT AMOUNT FOR 'BIG; WHERE TYPE =BIG THEN SUM(AMOUNT)-- ONLY BIG REALTED values

like wise small related sum(amount)

i want write expressions indidually.

Re: urgent expression?

senpradip007 — Tue, 11 Nov 2014 09:40:31 GMT

Could you please more descriptive?

Re: urgent expression?

jonathandienst — Tue, 11 Nov 2014 09:41:36 GMT

You need some sort of association between the amount field and the type field. Or some rule which can be used to identify which amounts are big and which are small.

Jonathan

Re: urgent expression?

Tue, 11 Nov 2014 09:43:15 GMT

when tupe is small then sum(amount) - small associated values sum(amount)

type is big then sum(amount) - long associated values sum(amount)

Re: urgent expression?

its_anandrjs — Tue, 11 Nov 2014 09:44:42 GMT

Hi,

Is this two fields AMOUNT and TYPE are in same table then please provide some data or you can use SET analysis for this.

Regards

Anand

Re: urgent expression?

ychaitanya — Tue, 11 Nov 2014 09:45:21 GMT

Amount_Table:

Load Amount,

If(Amount>300 ,'BIG' ,'SMALL')) as Type

From

Mysample.xls;

Type_Table:

Load * INLINE [ TYPE

'BIG'

'SMALL'

];

Then Assocaitions will be formed in Data Model and if you plot list boxes for Amount and Type .. then you can find the Big and Small amounts.

Hope this helps.

Mark the threads as helpful or answered which will help the others.

Thanks

Chaitanya

Re: urgent expression?

Tue, 11 Nov 2014 09:49:14 GMT

s pls tell me set analysis expression for this

Re: urgent expression?

anbu1984 — Tue, 11 Nov 2014 09:53:00 GMT

=sum({<type={'BIG'}>}amount)

Re: urgent expression?

ychaitanya — Tue, 11 Nov 2014 09:54:35 GMT

If( Type= 'BIG',Sum({$ <Type='BIG'>} Amount),Sum({$ <Type='SMALL'>} Amount))

Re: urgent expression?

its_anandrjs — Tue, 11 Nov 2014 09:56:55 GMT

Hi,

This are very simple SET analysis

For Big

sum({< TYPE = {'BIG'}>} amount)

with if condition

sum(If( TYPE = 'BIG' , amount ))

For Small

sum({< TYPE = {'SMALL'}>} amount)

With If condition

sum(If( TYPE = 'SMALL' , amount ))

Regards

Anand

Re: urgent expression?

MK_QSL — Tue, 11 Nov 2014 09:57:15 GMT

What is the Logic behind Small and Big Amount

i.e. Any amount less than equal to 100 is Small and Greater Than 100 is Big.. then use as below in your script

IF(AMOUNT <=100,'Small','Big') as AmountType

Re: urgent expression?

Tue, 11 Nov 2014 09:58:26 GMT

syntax eror pls check once

Re: urgent expression?

jagan — Tue, 11 Nov 2014 09:58:35 GMT

Hi Manoj,

Check this expression

For Big:

SUM({<TYPE = {'BIG'} >}AMOUNT)

For Small:

SUM({<TYPE = {'SMALL'} >}AMOUNT)

Hope this helps you.

Regards,

jagan.

Re: urgent expression?

anbu1984 — Tue, 11 Nov 2014 10:00:41 GMT

Try this =sum({<type={'BIG'}>}amount)

Re: urgent expression?

mjm — Tue, 11 Nov 2014 13:12:56 GMT

Hello Manoj,

if you have both Amount and Type listed as fields in your data source then the best way to achieve this would be through set analysis:

=Sum({$<Type={'Big'}>}Amount) - Sum of Amount where Type is Big

=Sum({$<Type={'Small'}>}Amount) - Sum of Amount where Type is Small

I have attached an example app to show you this.

Please mark this as completed and answered if this helps.