topic Re: Line Chart - Set Analysis - Expressions in QlikView

Line Chart - Set Analysis - Expressions

Fri, 21 Nov 2014 16:20:28 GMT

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.

Re: Line Chart - Set Analysis - Expressions

Fri, 21 Nov 2014 16:27:35 GMT

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

(Employees1>120,Employees1)

Re: Line Chart - Set Analysis - Expressions

MK_QSL — Fri, 21 Nov 2014 16:28:56 GMT

Go to expression tab

tick conditional and use below expression for conditional show

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

Re: Line Chart - Set Analysis - Expressions

Fri, 21 Nov 2014 16:39:59 GMT

Hi Manish

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

Re: Line Chart - Set Analysis - Expressions

Fri, 21 Nov 2014 16:43:10 GMT

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.

Re: Line Chart - Set Analysis - Expressions

MK_QSL — Fri, 21 Nov 2014 16:49:27 GMT

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

Re: Line Chart - Set Analysis - Expressions

Wed, 26 Nov 2014 09:05:40 GMT

Thanks a lot Manish...!!!