Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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)