How to count distinct values of different types over a rolling period ?
I'm struggling at finding a way to count distinct values over a rolling period, when these values are tagged with different "types".
For example, let's you wanna know to how many different customers you sold your product 'A' over the last year/quarter/etc...
I found this thread http://community.qlik.com/thread/123432 which is ALMOST what I'm looking for (see the last attachement) : it works great for a period/product/amount table, but results are irrelevant as soon as you include a "type" collumn, and try to visualize the results for one specific type.
Tried quite a few changes here and there but I'm stuck and I can't figure how to get past this issue.
I'll attach a file which is an adaptation of the solution of the above thread to my question, so you can see how it looks...