Set Analysis Query - Using Data Island on Table

Dayna — Wed, 10 May 2017 10:50:28 GMT

Hi All,

I hope I'm explaining myself correctly here. I have an application where I'd like to show the count of ProjectElement.Id where the created month (ProjectElement.MonthNameCreated) equals my master calendar month (Cal.MonthName), and the selected category (Product.Category.Name) equals my master category selector (Category.CategoryName).

I'm going to be extending this out soon to also look at the completed month, hence my use of master calendar here.

What I've got so far, is the set analysis on a table for the monthname, but it doesn't pay attention to the dimension and sums across all the values for the month. What I would expect for the month of January is:

Month	Category	Value
January 2017	Baby	7
January 2017	Facial	25
January 2017	Fem	1
January 2017	Household	13
January 2017	Medical	0
January 2017	Moist Toilet Tissue	1
January 2017	Other	0
January 2017	Personal Care	1
January 2017	Pet Care	0

But instead, unless I select the individual month, the table shows 62.

Ideally, I'd like to have this for all months, so this should show February, March, etc..

I think the set analysis needs to be something like:

count({<Element.Name = {'Launch'}, ProjectElement.MonthNameCreated= (Cal.MonthName), Product.Category.Name= (Category.CategoryName)>} DISTINCT ProjectElement.Id)

... but this doesn't return any results.

Can someone please help me!

Kind Regards,

Dayna

Re: Set Analysis Query - Using Data Island on Table

sunny_talwar — Wed, 10 May 2017 10:59:55 GMT

Set analysis won't work here... may be try with if statement

Count({<Element.Name = {'Launch'}>} DISTINCT If(ProjectElement.MonthNameCreated = Cal.MonthName, ProjectElement.Id))

Re: Set Analysis Query - Using Data Island on Table

Dayna — Wed, 10 May 2017 11:14:40 GMT

Looks good, thanks Sunny!

topic Set Analysis Query - Using Data Island on Table in QlikView

Set Analysis Query - Using Data Island on Table

Re: Set Analysis Query - Using Data Island on Table

Re: Set Analysis Query - Using Data Island on Table