Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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]))

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'

 

Re: Calculation Condition in chart doesn't work

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


talk is cheap, supply exceeds demand
Community Browser