topic Re: Date colors based on Condition?? in QlikView

Date colors based on Condition??

paulwalker — Fri, 03 Jan 2014 15:31:32 GMT

Hi All,

I Have a Date field,

I want to calculate like this..

[Date]<=10,'0-10',

[Date]<=20,'11-20',

[Date]<=35,'21-35',

[Date]<=45,'36-45','Lapsed'

how to calculate..

--Paul

swuehl — Fri, 03 Jan 2014 15:33:18 GMT

Try something like this in your script or frontend

if( [Date]<=10,'0-10',

if([Date]<=20,'11-20',

if([Date]<=35,'11-35',

if([Date]<=45,'36-45','Lapsed'))))

rustyfishbones — Fri, 03 Jan 2014 15:35:17 GMT

Hi Paul,

Did you try looking at using the Class function

paulwalker — Fri, 03 Jan 2014 15:38:40 GMT

Hi Swuehl,

Suppose i am using Straight table..

here calculate 4 columns 0-10,11-35, 36-45 and Lapsed

rustyfishbones — Fri, 03 Jan 2014 15:52:49 GMT

Create a Calculated Dimension and add Swuehl IF statement

to add colors just add it in the background color

like below