topic Calculation Condition in chart doesn't work in QlikView

Calculation Condition in chart doesn't work

viveksairam89 — Sat, 16 Nov 2024 04:52:25 GMT

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:

Site	Country
Mumbai	India
Chennai	India
Banglore	India

Table2:

Site	Country	KPI Name	KPI Values	Month
Mumbai	India	steel	1	Sep-18
Mumbai	India	Plant	1	Sep-18
Mumbai	India	Water	1	Sep-18
Banglore	India	steel	0	Sep-18
Banglore	India	Plant	1	Sep-18
Banglore	India	Water	0	Sep-18

Re: Calculation Condition in chart doesn't work

tresB — Mon, 31 Dec 2018 10:30:01 GMT

Try calculation condition like:

=Len(MaxString([KPI Name]))

Re: Calculation Condition in chart doesn't work

Gysbert_Wassenaar — Mon, 31 Dec 2018 10:30:45 GMT

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.

Re: Calculation Condition in chart doesn't work

viveksairam89 — Mon, 31 Dec 2018 10:55:09 GMT

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

Gysbert_Wassenaar — Mon, 31 Dec 2018 12:30:37 GMT

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