topic Re: Set analysis in QlikView

Set analysis

Thu, 19 Dec 2013 16:43:12 GMT

Hi all,

I have created a table, and the results is

FirstOrderCalendar.Month Name	count(order)	=monthname(AddMonths([FirstOrderCalendar.Month Name], 1))
	0
Jan 2013	0	Feb 2013
Feb 2013	0	Mar 2013
Mar 2013	0	Apr 2013
Apr 2013	0	May 2013
May 2013	0	Jun 2013
Jun 2013	0	Jul 2013
Jul 2013	0	Aug 2013
Aug 2013	0	Sep 2013
Sep 2013	0	Oct 2013
Oct 2013	0	Nov 2013
Nov 2013	0	Dec 2013
Dec 2013	0	Jan 2014

If i select on the table FirstOrderCalendar "Feb 2013", it's working, I have my count of orders

FirstOrderCalendar.Month Name	count(order)	=monthname(AddMonths([FirstOrderCalendar.Month Name], 1))
	16450	Mar 2013
Feb 2013	16450	Mar 2013

What's wrong with my set analysis ?

Why when I unselect Feb 2013 I have only 0 orders

=> Set analysis :

count({$<[SalesCalendar.Month Name]={'$(=only(DISTINCT monthname(AddMonths([FirstOrderCalendar.Month Name], 1))))'}>} [Order ID])

Re: Set analysis

javier_florian — Thu, 19 Dec 2013 16:55:07 GMT

Hi Adrien,

Did you tried with:

count({$<[SalesCalendar.Month Name]={'$(=only(DISTINCT [FirstOrderCalendar.Month Name]'}>} [Order ID])

Re: Set analysis

Thu, 19 Dec 2013 16:58:16 GMT

Yes I tried and still have 0...

Re: Set analysis

Thu, 19 Dec 2013 17:01:09 GMT

hi Adiren

and with a little = sign just before $

Chris

Re: Set analysis

Thu, 19 Dec 2013 17:04:49 GMT

Thanks for your answers, but I don't think it's a problem of = because it's working when I select one month (Table 2) - I think it's a problem when I have more than one month, set analysis doesn't work!

Re: Set analysis

Thu, 19 Dec 2013 17:26:45 GMT

Any ideas ? 😕

Re: Set analysis

Anonymous — Thu, 19 Dec 2013 19:09:07 GMT

As you are using "only" in the set analysis which means the expression will be evaluated only if one value of that field is selected.

Re: Set analysis

jerem1234 — Thu, 19 Dec 2013 20:39:51 GMT

You're better off using an if statement here, such as:

count(if([SalesCalendar.Month Name]=monthname(AddMonths([FirstOrderCalendar.Month Name], 1)), [Order ID]))

Hope this helps!

Re: Set analysis

Fri, 20 Dec 2013 08:57:52 GMT

yeah it's working !

thanks