Announcements
cancel
Showing results for
Did you mean:
Not applicable

## Between with more than 1 condition

Hi,

I want to create pivot table base on range value, i'll try with file attach, but the result isn't right,

Thank you

8 Replies
Specialist

HI Bam,

Likewise your 61-90 should follow the same format, and then the expression you have for >91 currently said <30 so you'll need to change that to >91!

Aaron

MVP

Create a Pivot Table

Dimension

1) Client

2) Calculated Dimension

=If(DueDate < 90, Dual(Replace(Class(DueDate,30),'<= x <','-'),Class(DueDate,30)), Dual('91 Days',10000))

Expression

Count(DueDate)

Partner - Champion III

Change these:

31-60 Days

count({<DueDate={'>=31'}, DueDate={'<=60'}>} ID)

to

count({<DueDate={">=31<=60"}>} DueDate)

61-90 Days

count({<DueDate={'>=61'}, DueDate={'<=90'}>} DueDate)

to

count({<DueDate={'>=61<=90'}>} DueDate)

>91 Days

count({<DueDate={'<=30'}>} DueDate)

to

count({<DueDate={">90"}>} DueDate)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Partner - Champion III

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Dear All,

Regards

MVP

Have you tried my solution?

Not applicable
Author

I try too Mr. Kachhia, but your expression is too great for me :-), because I am newbie in qv, I am still confused to handle your expression and I missed periode between 31 - 60 Days.

Thank you

MVP

let me know which part you don't understand in my provided expression.

I will explain in steps...

Community Browser