topic Re: U R G E N T - Set Analysis Help required in QlikView

U R G E N T - Set Analysis Help required

vikasmahajan — Fri, 16 Aug 2013 04:35:35 GMT

Dear All

I have following expression for calculating sales as per user selected month and year ,

I want to display same set of expression for last year as per user selected month and year dynamically.

(SUM({$<FiscalYear={$(=max(FiscalYear))}>}[Sales Invoice Qty])

SUM({$<FiscalYear={$(=max(FiscalYear))}>}[Sales Return Qty])

)/1000

Thanks in advance

Vikas

Re: U R G E N T - Set Analysis Help required

tresB — Fri, 16 Aug 2013 04:50:42 GMT

Have you tried this?:

(SUM({$<FiscalYear={$(=(max(FiscalYear)-1))}>}[Sales Invoice Qty])

SUM({$<FiscalYear={$(=(max(FiscalYear)-1))}>}[Sales Return Qty])

)/1000

Re: U R G E N T - Set Analysis Help required

vikasmahajan — Fri, 16 Aug 2013 04:53:04 GMT

Hello

Thanks For Immediate reply I have try the same but unfortunately I am not getting results .

any idea ?

Vikas

Re: U R G E N T - Set Analysis Help required

tresB — Fri, 16 Aug 2013 04:57:01 GMT

Can a sample app be posted?

Re: U R G E N T - Set Analysis Help required

vikasmahajan — Fri, 16 Aug 2013 05:03:33 GMT

No Application can be share.

Re: U R G E N T - Set Analysis Help required

MayilVahanan — Fri, 16 Aug 2013 05:16:32 GMT

Try like this

(SUM({1<FiscalYear={$(=max(FiscalYear)-1)}>}[Sales Invoice Qty])

SUM({1<FiscalYear={$(=max(FiscalYear)-1)}>}[Sales Return Qty])

)/1000

Re: U R G E N T - Set Analysis Help required

vikasmahajan — Fri, 16 Aug 2013 05:26:31 GMT

I think this will not work Set analysis will ignore user selection dimension if we use 1 identifier.

sum({1} Sales) => Returns total sales within the application, disregarding selections but not

the dimension.

Thanks

Vikas

Re: U R G E N T - Set Analysis Help required

CELAMBARASAN — Fri, 16 Aug 2013 05:35:41 GMT

Hi,

Below expression will work.

(SUM({$<FiscalYear={$(=Max(FiscalYear)-1)}>} [Sales Invoice Qty])

SUM({$<FiscalYear={$(=Max(FiscalYear)-1)}>} [Sales Return Qty])

)/1000

Make sure that you don't have any data issues.

Also shouldn't get divide by zero error means SUM({$<FiscalYear={$(=Max(FiscalYear)-1)}>} [Sales Return Qty]) expression should result zero.

Re: U R G E N T - Set Analysis Help required

tresB — Fri, 16 Aug 2013 05:36:39 GMT

You can share your application without worring about data, look at this and this too.

Re: U R G E N T - Set Analysis Help required

vikasmahajan — Fri, 16 Aug 2013 06:17:32 GMT

Thx a lot for your quick answer.

I tried and unfortunately it doesn't work.

Re: U R G E N T - Set Analysis Help required

vikasmahajan — Fri, 16 Aug 2013 06:43:04 GMT

Hello I have attached the demo example please help me ,

IF user selects Month and year then sales related to month and year should display vs last year same months and year sets.

Thanks

Vikas

Re: U R G E N T - Set Analysis Help required

MayilVahanan — Fri, 16 Aug 2013 06:53:17 GMT

Its work fine. When u select the fiscal year.

If u select fiscal year - 2013, its display 2013 value and 2012 value

For 2012 , there is no data, so it display zero.

Please find attachment

Re: U R G E N T - Set Analysis Help required

vikasmahajan — Fri, 16 Aug 2013 07:05:41 GMT

Thanks I thing you have not understand what exact I want

If user will select fin year 2013 and month may & june I want to display may+june sale (2013 ) vs may+june(2012) I want to display,

Is there any solutiion ?

Re: U R G E N T - Set Analysis Help required

tresB — Fri, 16 Aug 2013 07:13:11 GMT

Vikas,

Expression should be:

SUM({$<FinancialYear=,FiscalYear={$(=(Max(FiscalYear)-1))}>} [Sales Invoice Qty])

PFA

Re: U R G E N T - Set Analysis Help required

vikasmahajan — Fri, 16 Aug 2013 09:14:50 GMT

Thanks to all

Finally resolve with following link

http://community.qlik.com/message/313514#313514

Vikas

Re: U R G E N T - Set Analysis Help required

paulyeo11 — Fri, 16 Aug 2013 09:28:58 GMT

Hi tres

i like the 2 link you posted. very useful info.