topic Re: Between with more than 1 condition in QlikView

Between with more than 1 condition

Fri, 02 Oct 2015 08:34:05 GMT

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

Re: Between with more than 1 condition

morganaaron — Fri, 02 Oct 2015 09:55:35 GMT

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

Re: Between with more than 1 condition

MK_QSL — Fri, 02 Oct 2015 09:56:46 GMT

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)

Re: Between with more than 1 condition

jonathandienst — Fri, 02 Oct 2015 10:03:07 GMT

Change these:

31-60 Days

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

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

61-90 Days

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

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

>91 Days

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

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

Re: Between with more than 1 condition

jonathandienst — Fri, 02 Oct 2015 10:05:06 GMT

Re: Between with more than 1 condition

Fri, 02 Oct 2015 17:25:58 GMT

Dear All,

Thank you for your kindness

Regards

Re: Between with more than 1 condition

MK_QSL — Fri, 02 Oct 2015 21:45:09 GMT

Have you tried my solution?

Re: Between with more than 1 condition

Sat, 03 Oct 2015 00:36:52 GMT

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

Re: Between with more than 1 condition

MK_QSL — Sun, 04 Oct 2015 20:38:50 GMT

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

I will explain in steps...