Line Chart - Set Analysis - Expressions

[#1]

In the Qlikview file attached here, a line chart represents number of employees over the Years in a company. I would like to update my expression so as to show the line chart only if the number of employees for any one of the years is greater than a threshold (120 in this case). That is, if number of employees for any one of the years is less than 120, the line chart should not be displayed. Otherwise complete chart should be displayed.

[#2]

You can use the below expression in the chart expression tab instead of Employees1.

(Employees1>120,Employees1)

[MK_QSL]

Go to expression tab

tick conditional and use below expression for conditional show

=IF(Min(Aggr(SUM(Employees),Year))<=120,'0','1')

[#4]

Hi Manish

Shouldn't there be >= instead of <= in the above condition?

[#5]

I noticed that this condition is not working correctly. If I change threshold to 160 and write >= 160 instead of >= 120, the chart still appears.

[MK_QSL · Accepted solution]

If Employee Count less than 120 means 0 so it will not show the line chart

[#7]

Thanks a lot Manish...!!!