Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

BAR graph showing no data

Please find the attached file containg my applicsation-

I am facing problem please help-

1. If I click on B/C on "ticket type" dimension then BAR graph data is not coming but i am not facing problem for A in ticket type.

2. In the TICKET Detail straingt table colour coding is not coming perfectly-

Example- EF3304015 , EF3315393 - here resolution time is less than KPI time but still it is showing RED.

Please help

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

Maketime(24,0) returns null -> Midnight of next day

Try using

If( DurationStefan > Interval(KPI_TIME/24) , LightRed(70), LightGreen() )

as background color expression

View solution in original post

10 Replies
Clever_Anjos
Employee
Employee

Try using Count (ID) instead of NumericCount(ID) since for B/C your ID´s are strings, not numbers

avinashelite

use the count(ID) in the expression

Clever_Anjos
Employee
Employee

IF KPI_TIME is measured in hours, then your color expression should be:

If( DurationStefan > MakeTime(KPI_TIME,0) , LightRed(70), LightGreen() )

Anonymous
Not applicable
Author

EF3225969-color code is not coming properly

Clever_Anjos
Employee
Employee

EF3225969 took 220 hours, should be marked as red, right?

Anonymous
Not applicable
Author

no showing green but it should red

Clever_Anjos
Employee
Employee

It´s red here

Which formula are you using at Backgound color?

Capturar.PNG

Anonymous
Not applicable
Author

Hi Anjos,

Thanks for constantly replying.

I have used formula which yoiu have suggested.

Please find the attached file.

Please let me knoiw if i am missing out.

Regards

Anonymous
Not applicable
Author

need suggwstion (file atached)