topic Re: BAR graph showing no data in QlikView

BAR graph showing no data

Anonymous — Tue, 13 Oct 2015 13:45:33 GMT

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 — Tue, 13 Oct 2015 13:52:20 GMT

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

avinashelite — Tue, 13 Oct 2015 13:56:11 GMT

use the count(ID) in the expression

Clever_Anjos — Tue, 13 Oct 2015 13:56:29 GMT

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

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

Anonymous — Tue, 13 Oct 2015 15:33:39 GMT

EF3225969-color code is not coming properly

Clever_Anjos — Tue, 13 Oct 2015 15:47:47 GMT

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

Anonymous — Tue, 13 Oct 2015 16:07:45 GMT

no showing green but it should red

Clever_Anjos — Tue, 13 Oct 2015 16:09:05 GMT

It´s red here

Which formula are you using at Backgound color?

Anonymous — Tue, 13 Oct 2015 17:35:29 GMT

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 — Tue, 13 Oct 2015 18:59:08 GMT

need suggwstion (file atached)

Clever_Anjos — Tue, 13 Oct 2015 19:07:40 GMT

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

Try using

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

as background color expression