topic Cumulative Number-of-points between 2 months in QlikView

Cumulative Number-of-points between 2 months

arsa6978 — Fri, 07 Apr 2017 07:55:01 GMT

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

Re: Cumulative Number-of-points between 2 months

arsa6978 — Mon, 10 Apr 2017 08:10:54 GMT

Does any one has any idea?

Re: Cumulative Number-of-points between 2 months

ElizaF — Mon, 10 Apr 2017 08:38:49 GMT

Hello,

Try "The As-Of Table" concept

The As-Of Table

Re: Cumulative Number-of-points between 2 months

arsa6978 — Mon, 10 Apr 2017 14:14:36 GMT

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.

Re: Cumulative Number-of-points between 2 months

ElizaF — Mon, 10 Apr 2017 16:13:55 GMT

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.

Re: Cumulative Number-of-points between 2 months

arsa6978 — Tue, 11 Apr 2017 08:00:22 GMT

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?