topic Re: Need help in set analysis in QlikView

Need help in set analysis

Tue, 20 Nov 2012 05:26:47 GMT

Hello Friends,

I have used the following expression to find the last year sales with the mode of transport is 'Road'

=If([Type]='Road',Sum({$<ShipmentYear={$(=Year(Today())-1)}>} Sales)),

2. and also the TYPE may be dynamic based on selection it has to show the last year sales.

Regards

Chriss

Re: Need help in set analysis

Tue, 20 Nov 2012 05:34:29 GMT

Hi Chris,

Whats The Output You Have?

Try This =If([Type]=Road,Sum({$<ShipmentYear={$(=ShipmentYear(Today())-1)}>} Sales))

Can You Please Share Your test app with me.

Thanks & Regards,

Nirmal.

Re: Need help in set analysis

Tue, 20 Nov 2012 05:42:12 GMT

Hello Nirmal,

There is no output is coming for the expression but there is no error is showing on the expression.

I don't know where I am making a mistake, could you please tell me how to proceed further.

Reards

Chriss

Re: Need help in set analysis

Tue, 20 Nov 2012 05:45:22 GMT

Are You use the Below expression.

=If([Type]=Road,Sum({$<ShipmentYear={$(=ShipmentYear(Today())-1)}>} Sales))

Re: Need help in set analysis

Tue, 20 Nov 2012 05:54:41 GMT

Hello Nirmal,

The same is used by me, there is no result...

Regards

Chriss

Re: Need help in set analysis

Tue, 20 Nov 2012 05:56:05 GMT

create one variable for last year like

vyear=year(today())-1

sum({<type={'road'},ShipmentYear={">=$(vyear)"}>}sales)

use it

Re: Need help in set analysis

Tue, 20 Nov 2012 06:01:49 GMT

create one variable for last year like

vyear=year(today())-1

if(type=Road,sum({$<ShipmentYear={"<=$(vyear)>"}>}sales))

use it

Re: Need help in set analysis

CELAMBARASAN — Tue, 20 Nov 2012 13:59:04 GMT

Hi,

Check with this

=Sum({<[Type]={'Road'},ShipmentYear={$(=Year(Today())-1)}>} Sales)

=Sum({<[Type]={'Road'},ShipmentYear={$(=Year(AddYears(Today(),-1))}>} Sales)

Hope it helps