Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
viveksairam89
Creator
Creator

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
Labels (4)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try calculation condition like:

=Len(MaxString([KPI Name]))

View solution in original post

4 Replies
tresesco
MVP
MVP

Try calculation condition like:

=Len(MaxString([KPI Name]))

View solution in original post

Gysbert_Wassenaar

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
Creator
Creator
Author

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'

 

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand