Cobwebs of Set Analysis

[#1]

Hi guys,

Could some of you help me to understand one thing. I need to count a quantity of CaseId in appropriate month, where CaseId were in previous month. I have variable vOneMonth which define previous month, but anyway the end result isn't correct. For example, for period 2012-04 the result should be 0 because we don't have previous period 2012-03. Please help!!!

[fosuzuki]

What if you do the logic in the script?

Check the attached qvw.

Hope this helps

Fernando

[#3]

Hi,

You can change your set anaysis for one and two.

count({$<Period = {"=$(vOneMonth)"}>} CaseId)

count({$<Period = {"=$(vTwoMonth)"}>} CaseId)

Regards,

Janzen

[#4]

The common problem is that i need to calculate quantity of unique CaseId for 3 month (in dimension period + 3 period above).

http://community.qlik.com/message/271888#271888