Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
arsa6978
New Contributor III

Cumulative Number-of-points between 2 months

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

1 Solution

Accepted Solutions
ElizaF
Contributor II

Re: Cumulative Number-of-points between 2 months

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.


5 Replies
arsa6978
New Contributor III

Re: Cumulative Number-of-points between 2 months

Does any one has any idea?

ElizaF
Contributor II

Re: Cumulative Number-of-points between 2 months

Hello,

Try "The As-Of Table" concept

The As-Of Table

arsa6978
New Contributor III

Re: Cumulative Number-of-points between 2 months

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
Contributor II

Re: Cumulative Number-of-points between 2 months

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
New Contributor III

Re: Cumulative Number-of-points between 2 months

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?