topic Re: using built in functions within set analysis in QlikView

using built in functions within set analysis

Fri, 18 Oct 2013 05:28:37 GMT

Hi,

I have been tring to get the metric value for the current year and month being current month-1.

Below is the expression that i have used to acheive the same.But i am not getting any valid results

=only({$<My_Year={'=$(=year(today())'},
My_Month={'=$(=Month(AddMonths(today(),-1))'}>}Value)

Can anyone let me know where i have gone wrong

Re: using built in functions within set analysis

tresB — Fri, 18 Oct 2013 05:36:31 GMT

Two things come in mind:

1. If there are more than one values for Value for current year previous month, ONLY() would return NULL

2. My_Month format may not be matching.

Re: using built in functions within set analysis

jagan — Fri, 18 Oct 2013 05:46:07 GMT

Hi,

If there are multiple values for Value dimension then you will get a null value, check this. If there are multiple values then try using any max, min, sum functions.

Also make sure that My_Month and =Month(AddMonths(today(),-1)) are in the same format.

Hope this helps you.

Regards,

Jagan.

Re: Re: using built in functions within set analysis

Fri, 18 Oct 2013 06:04:21 GMT

I did try with sum even then i am getting Null as the result.I have attached thae sample application too so please have a look and let me know where i have gone wrong

Re: using built in functions within set analysis

tresB — Fri, 18 Oct 2013 06:10:17 GMT

Attachment?

Re: using built in functions within set analysis

Fri, 18 Oct 2013 06:16:56 GMT

Thanks & Regards,

Anushree Shetty

Re: Re: using built in functions within set analysis

tresB — Fri, 18 Oct 2013 06:23:52 GMT

PFA,

It was parenthesis issue.