Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I count the number of clients in the previous month , with the year and month dimension??

How are you.

I'm learning QlikView .

To ask how I can count the total number of customers having a dimension year and month .

Example:

I need you in the month of January show me the total in December , in February I show in January month

Thank you....


tabla.png

1 Solution

Accepted Solutions
sunny_talwar

May be try and use Above() function:

Above(YourExpressionForCurrentMonth)

View solution in original post

5 Replies
sunny_talwar

May be try and use Above() function:

Above(YourExpressionForCurrentMonth)

Not applicable
Author

It was what i needed

Thank you very much

Not applicable
Author

One question, when making the above() function, give me the desired results just in leap year gives me the result of month on my table , Why ?

Annex table example :tabla.png


sunny_talwar

Not sure I understand your issue?

Not applicable
Author

It 's an example :

In my table I have 2014.2015 when making the leap year from December to January data does not appear .

I explain?