Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead 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,

help me please.

Thank you

8 Replies
morganaaron
Specialist
Specialist

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
MVP
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)

jonathandienst
Partner
Partner

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
jonathandienst
Partner
Partner

t5.png

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

Dear All,

Thank you for your kindness

Regards

MK_QSL
MVP
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

MK_QSL
MVP
MVP

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

I will explain in steps...