topic Re: Set Analysis expression issue in QlikView

Set Analysis expression issue

Mon, 09 Dec 2013 07:20:44 GMT

Hi all,

This is my expression:

=sum({1<Month={$(vMaxDate)}>} [Subscriber Count])

vMaxDate has a value (a date).

when I filter by regular selection I see a value under the next expression: =sum([Subscriber Count])

but I'm trying the set analysis to fix this calculation to the max Date and I get 0.

why can it be?

Thanks,

Boris

Re: Set Analysis expression issue

Mon, 09 Dec 2013 08:02:59 GMT

Hi Boris,

The syntax seem OK but:

1) check that the variable contains a valid Month

2) check that the value does not contain any blank or any specific character. If so, you must enclose your variable between brackets: []

=> [$(variable)]

Fabrice

Re: Set Analysis expression issue

Mon, 09 Dec 2013 08:04:34 GMT

if your vriable contains a date try this:

=sum({1<Month={ ' $(vMaxDate) ' }>} [Subscriber Count])

when your variable contains a string you need to enclose your variables - otherwise it wont work. It only works with int datatypes.

And moreover be sure you use the correct datefield. Maybe it should be your datefield instead of Month?

Re: Set Analysis expression issue

Mon, 09 Dec 2013 08:43:17 GMT

Still doesn't work.

Re: Set Analysis expression issue

Mon, 09 Dec 2013 08:43:59 GMT

can u post ur document sample?

Re: Set Analysis expression issue

Mon, 09 Dec 2013 08:48:46 GMT

try this

=sum({1<Month={ $(=Date(vMaxDate)) }>} [Subscriber Count])

Re: Set Analysis expression issue

Mon, 09 Dec 2013 08:52:47 GMT

can you that variable which is given by you

vMaxDate=

Re: Set Analysis expression issue

Mon, 09 Dec 2013 09:46:26 GMT

Hi, attached is the sample that doesn't work

Re: Set Analysis expression issue

Mon, 09 Dec 2013 09:50:34 GMT

try this

=sum({<Month={ '=$(=Date(vMaxDate)) ' }>} [Subscriber Count])

Re: Set Analysis expression issue

Mon, 09 Dec 2013 09:50:55 GMT

first of all ur peek is wrong i think

try this:

let vMaxMonth=peek ('Month',-1,'MAX_Month');

As i can see your max month is 12/1/2013 - I dont know if this is due to sample data. But beaware of this..

Re: Set Analysis expression issue

Mon, 09 Dec 2013 09:53:14 GMT

the value of the variable is right. so the peek is correct

Re: Set Analysis expression issue

Mon, 09 Dec 2013 09:53:26 GMT

doesn't work

Re: Set Analysis expression issue

Mon, 09 Dec 2013 09:54:04 GMT

there is no data on the 12/1/2013 - unless its due to demo data?

Re: Set Analysis expression issue

Mon, 09 Dec 2013 09:58:52 GMT

Try this demo, it is full with data, with 2 objects, one with regular selection and one with the set analysis.

Re: Set Analysis expression issue

Mon, 09 Dec 2013 10:00:11 GMT

try this:

=sum({<Month={"=$(=Date(Max(Month)))"}>} [Subscriber Count])

Re: Set Analysis expression issue

jagan — Mon, 09 Dec 2013 10:01:43 GMT

Hi,

Use this expression, you are using wrong variable.

=sum({1<Month={'$(vMaxMonth)'}>}[Subscriber Count])

Regards,

Jagan.

Re: Set Analysis expression issue

Mon, 09 Dec 2013 10:02:53 GMT

Sorry, Thanks!

Re: Set Analysis expression issue

Mon, 09 Dec 2013 10:03:05 GMT

haha plus 1 - Didnt see that