Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
alknirmal1
Partner
Partner

Condional formatting - with calculated dimension

Hi ,

I have a calculated dimension to calculate the age buckets for claims with respect to toddy's date in a block chart.

Calculated Dimension :

=IF((Today()-[Claim Received Date])>=-45 and (Today()-[Claim Received Date])<-15  ,'-45 to -15',

IF((Today()-[Claim Received Date])>=-14 and (Today()-[Claim Received Date])<-1  ,'-14 to -1',

IF((Today()-[Claim Received Date])>=0 and (Today()-[Claim Received Date])<=45  ,'0-45',

)))

Expression :

Count(Claim Number)

I have requirement of coloring the block chart with the below colors for each range.

0-45

Green

-14 to -1

Blue

-45 to -15

yellow

How can I achieve this requirement.?

I tried putting a background expression in the expression and its not working. What is the right way of doing  it ?

Appreciate your help on this.

Thanks

NV

10 Replies
balabhaskarqlik

May be:

You can specify format as #,##0.00;(#,##0.00) in chart properties on the Number tab

Or use Num function like Num(Your_Calc, '#,##0.00;(#,##0.00)')

By this it'll identify the positive & negative values.