Solved: Re: BAR graph showing no data - Qlik Community

Anonymous · ‎2015-10-13

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

Clever_Anjos · ‎2015-10-13

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

Try using

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

as background color expression

Clever_Anjos · ‎2015-10-13

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

avinashelite · ‎2015-10-13

use the count(ID) in the expression

Clever_Anjos · ‎2015-10-13

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

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

Anonymous · ‎2015-10-13

EF3225969-color code is not coming properly

Clever_Anjos · ‎2015-10-13

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

Anonymous · ‎2015-10-13

no showing green but it should red

Clever_Anjos · ‎2015-10-13

It´s red here

Which formula are you using at Backgound color?

Anonymous · ‎2015-10-13

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 · ‎2015-10-13

need suggwstion (file atached)