Trouble with Set analysis

jjbom1990 — Tue, 10 Aug 2021 06:40:13 GMT

I tried finding solutions on the forum but I can't seem to find the same problem. I am having trouble with set analysis.

Probably because I am trying to count the weeks within a date selection. However de data is obviously linked to the facts.

The expression to count weeks:

count({1<Year=$::Year,Month=$::Month,Quarter=$::Quarter>}distinct YearWeek)

This works fine without being put into a table with dimensions. In a text box it nicely displays 5 weeks voor August 2021.

However putting this into a table where there is only 1 order in 1 week it counts the weeks as 1 instead of 5.

Week	Order
1
2	Order no.
3
4
5

The avg deliveries per week --> 1 / count({1<Year=$::Year,Month=$::Month,Quarter=$::Quarter>}distinct YearWeek) = 1 instead of the expected 0.2. how to overcome this?

Thanks in advance

Re: Trouble with Set analysis

jjbom1990 — Wed, 11 Aug 2021 09:44:06 GMT

I seem to have been able to get the desired result using Total in the expression count(TOTAL{1<Year=$::Year,Month=$::Month,Quarter=$::Quarter>}distinct YearWeek)

topic Re: Trouble with Set analysis in QlikView

Trouble with Set analysis

Re: Trouble with Set analysis