Between with more than 1 condition

[#1]

Hi,

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

help me please.

Thank you

[morganaaron]

HI Bam,

Your condition for 31-60 days should read: count({<DueDate={'>=31<=60'}>} ID)

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

[MK_QSL]

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)

[jonathandienst]

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)

[jonathandienst]

[#6]

Dear All,

Thank you for your kindness

Regards

[MK_QSL]

Have you tried my solution?

[#8]

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

[MK_QSL]

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

I will explain in steps...