topic Re: Set ANalysis !! in QlikView

Set ANalysis !!

nikhilgarg — Fri, 19 Sep 2014 10:24:29 GMT

HEy,

In my excel sheet , i have 3 columns : Year , Customer , Sales.

I want to show Customer name for last year.

I have used following set analysis but it is giving error. Kindly tell em what to do.

Customer = p({<Year={$(max(Year)}-1>})

Thanks

Re: Set ANalysis !!

MK_QSL — Fri, 19 Sep 2014 10:26:44 GMT

Create a Straight Table

Dimension

1) Year

2) =IF(Year = (Year(Today())-1),Customer)

Tick Suppress When Value is Null for 2nd Dimension

Expression

SUM(Sales)

Re: Set ANalysis !!

tresB — Fri, 19 Sep 2014 10:26:59 GMT

Try like:

Customer = p({<Year={"$(=max(Year)-1)"}>})

Re: Set ANalysis !!

nikhilgarg — Fri, 19 Sep 2014 10:29:43 GMT

Hey,

It is still giving me error.

Re: Set ANalysis !!

anbu1984 — Fri, 19 Sep 2014 10:30:36 GMT

Can you post sample qvw

Re: Set ANalysis !!

tresB — Fri, 19 Sep 2014 10:30:45 GMT

Try to post your complete expression.

Re: Set ANalysis !!

perumal_41 — Fri, 19 Sep 2014 10:31:49 GMT

Hi Nikhil,

for getting customer for last year : only({<Year={'$(=max(Year))-1>}) Customer)

for getting sales for last year : Sum({<Year={'$(=max(Year))-1>}) Sales)

Re: Set ANalysis !!

nikhilgarg — Fri, 19 Sep 2014 10:31:51 GMT

Hey,

In my question , i have already uploaded my expression.

Thanks

Re: Set ANalysis !!

tresB — Fri, 19 Sep 2014 10:34:58 GMT

Missing quotes; improper parenthesis. Try:

only({<Year={'$(=max(Year)-1)'}>} Customer)

sum({<Year={'$(=max(Year)-1)'}>} Sales)

:Note: Only() would only work if there is single customer for the max year, otherwise, try with concat(),k like:

Concat({<Year={'$(=max(Year)-1)'}>} Customer, ',')

Re: Set ANalysis !!

varunjain — Fri, 19 Sep 2014 10:34:59 GMT

try this

ONLY( {$<Customer = p({<Year={"$(=max(Year)-1)"}>})>} Customer )

Re: Re: Set ANalysis !!

nikhilgarg — Fri, 19 Sep 2014 10:38:52 GMT

See the attached file

Re: Re: Set ANalysis !!

nikhilgarg — Fri, 19 Sep 2014 10:39:26 GMT

See the attached file

Re: Re: Set ANalysis !!

nikhilgarg — Fri, 19 Sep 2014 10:39:58 GMT

See the attached

Re: Set ANalysis !!

sundarakumar — Fri, 19 Sep 2014 10:50:28 GMT

Hi,

PFA. This should help..

I have done it in my own example..

-Sundar

Re: Re: Re: Set ANalysis !!

Fri, 19 Sep 2014 11:12:41 GMT

HI,

Result of your attached file,

PFA