Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

viveksairam89
Contributor

Calculation Condition in chart doesn't work

Hi 

I have a site Table1  and KPI Data table2,

i am using a chart ,just i want to display red or green based on the site,if the KPI name is steel and kpi value is 1 it should be green or else it should be red,if the site doesnt have value then it should produce a Display message No data for the site

I have attached the QVW iam getting the problem in calculation condition

Table1:

SiteCountry
MumbaiIndia
ChennaiIndia
BangloreIndia

 

Table2:

SiteCountryKPI NameKPI ValuesMonth
MumbaiIndiasteel1Sep-18
MumbaiIndiaPlant1Sep-18
MumbaiIndiaWater1Sep-18
BangloreIndiasteel0Sep-18
BangloreIndiaPlant1Sep-18
BangloreIndiaWater0Sep-18
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Calculation Condition in chart doesn't work

Try calculation condition like:

=Len(MaxString([KPI Name]))
4 Replies
Highlighted
MVP
MVP

Re: Calculation Condition in chart doesn't work

Try calculation condition like:

=Len(MaxString([KPI Name]))
MVP & Luminary
MVP & Luminary

Re: Calculation Condition in chart doesn't work

To be honest I have no idea what you're trying to do. However 'Steel' and 'steel' are two different values. Make sure to use the correct value.

talk is cheap, supply exceeds demand
viveksairam89
Contributor

Re: Calculation Condition in chart doesn't work

Thanks for the reply

I am trying to put if steel value is 1 its Green Dot,else Steel value is 0 its should be Red Dot based on the Site

If Selected site doesn't have Value it should display a message 'No Data for Chennai'

 

MVP & Luminary
MVP & Luminary

Re: Calculation Condition in chart doesn't work

Ok, try this as calculation condition: =count([KPI Name])


talk is cheap, supply exceeds demand