Cumulative Number-of-points between 2 months

[arsa6978]

Hello Community,

pls take a look at attached sample.

I want to know how many customers per Company have more than 1000 Points every Month .

For example the customer 310350 has two Orders in March and May.

How can i show that he has more than 1000 Cumulative Number-of-points in april too?

Thanks for your help!

marcus_sommer‌

swuehl‌

stalwar1‌

QlikView Creating Analytics‌

German User Group - Deutsche User Group‌

Nachricht geändert durch arash sasan

[arsa6978]

Does any one has any idea?

[ElizaF]

Hello,

Try "The As-Of Table" concept

The As-Of Table

[arsa6978]

Hi Eliza,

thanks very much, it works!

Do you have any approach, how can i adopt it to selected values in calendar?

if i select Mai 2016 in Calendar i want to see the values only in Mai 2016 not more ...

And the Calendar schould remain the same.

[ElizaF · Accepted solution]

My pleasure .

My approach is to use in the Calendar the AsOfMonth fields.

Also, i don't thing you need the [CumulativeNumber-of-points] values in script. You can calculated in the interface the cumulative value.

Pls check the attached file.

[arsa6978]

Elizia,

but i have to use only the master calendar (without fields) in the application and it is confusing to have an extra AsOfMonth Listfield.

I your Set Analysis you have "MonthDiff = {0}". That is what i was looking for, Thanks! .

I think it is more performant to use a flag based on "CumulativeNumber-of-points" as to check "customer with more than 1000 points per Month" in the interface, or i did'nt get your point?