topic set analysis in QlikView

set analysis

Tue, 09 Jul 2013 17:54:31 GMT

Hi everyone;

How i can get the sales from last years with the next expression that show the sales actually year:

sum(if(CURRENCY_FILTRO='USD',(((ventapesos)/1000)/rate_usd),(ventapesos)/1000))

regards!!!

Re: set analysis

nirav_bhimani — Tue, 09 Jul 2013 19:31:21 GMT

Hi,

Try the following expressions

Current Year Sales: 2013

sum({<FinancialYear = {"$(=Max(FinancialYear))"}>}Sales)

Last Year Sales: 2012

Sum({<FinancialYear = {"$(=Max(FinancialYear)-1)"}>}Sales)

Last to Last Year Sales: 2011

Sum({<FinancialYear = {"$(=Max(FinancialYear)-2)"}>}Sales)

Regards,

Nirav Bhimani

Re: set analysis

Tue, 09 Jul 2013 19:37:14 GMT

Thanks Nirav for your help but i neet too the dimention called CURRENCY_FILTRO with the IF.

regards!!

Re: set analysis

nirav_bhimani — Tue, 09 Jul 2013 19:52:37 GMT

Hi,

You want to use If condition then

(if(CURRENCY_FILTRO='USD',

((sum({<FinancialYear = {"$(=Max(FinancialYear))"}>}ventapesos)/1000)/rate_usd) ,

(sum({<FinancialYear = {"$(=Max(FinancialYear))"}>}ventapesos)/1000)

Regards,

Nirav Bhimani

Re: set analysis

Sokkorn — Wed, 10 Jul 2013 04:03:51 GMT

Hi,

You can try this:

Last year sale:

=If([CURRENCY_FILTRO]='USD',

Sum({$<[SaleYear] = {$(=Max([SaleYear])-1)}>} (ventapesos/1000)/rate_usd)

Sum({$<[SaleYear] = {$(=Max([SaleYear])-1)}>} ventapesos/1000)

)

Current year sale:

=If([CURRENCY_FILTRO]='USD',

Sum({$<[SaleYear] = {$(=Max([SaleYear]))}>} (ventapesos/1000)/rate_usd)

Sum({$<[SaleYear] = {$(=Max([SaleYear]))}>} ventapesos/1000)

)

Above expression just a clue for you to get start.

Regards,

Sokkorn

Re: set analysis

Wed, 10 Jul 2013 12:40:41 GMT

thanks everyone i will try today this responses i was in in labor board

Regards!!

Re: set analysis

Mon, 15 Jul 2013 21:58:38 GMT

Thanks very much !!! work it !!!