topic Re: IF Stmnt in Expression is not working in Chart in QlikView

IF Stmnt in Expression is not working in Chart

Wed, 18 Jun 2014 14:19:10 GMT

The IF statement in the Dimension of a Straight Table is working fine,but when i try to use the same IF statement with a minimal modification in the Expression of a Chart it returns nothing.

The IF statement used in the Dimension is given below.

=if(aggr((Sum({$<$(vUtlExceptions)>}Utilization)/Sum({$<$(vUtlExceptions)>}Available)<=.5), Name, [M1 Mgr Name], [M2 Mgr Name],[M3 Mgr Name]) , Name)

The above statement is checking if the Utilization% is less than equal to 50% then Display the name of those Employees,along with their managerial hierarchy.

Similarly i wanted to show the Count of Employees under each and every M1 Manager whose Utilization is LE (<=) 50%.

There on the Chart i have used M1 Manager in the Dimension and on the Expression tab i am trying to use the below IF statement,but it is not returning any results.

=if(aggr((Sum({$<$(vUtlExceptions)>}Utilization)/Sum({$<$(vUtlExceptions)>}Available)<=.5)),Count([Employee Id]))

I would appreciate if anybody can guide me on how to showt the count of Employees whose Utilization% id <= 50%.

Thanks in advance.

Vineet

Re: IF Stmnt in Expression is not working in Chart

Gysbert_Wassenaar — Wed, 18 Jun 2014 14:32:02 GMT

Count({<[Employee Id]={'=Sum({$<$(vUtlExceptions)>}Utilization)/Sum({$<$(vUtlExceptions)>}Available)<=.5'}>} [Employee Id])

Re: Re: IF Stmnt in Expression is not working in Chart

Wed, 18 Jun 2014 17:20:26 GMT

Hi Gysbert

Thanks for giving a shot but i am sorry to say that the statement provided by you is simply giving me the count of Employees.

Please find the attached qvw file.

Re: Re: Re: IF Stmnt in Expression is not working in Chart

Gysbert_Wassenaar — Wed, 18 Jun 2014 17:38:22 GMT

See attached qvw

Re: IF Stmnt in Expression is not working in Chart

Thu, 19 Jun 2014 11:22:31 GMT

Yet to get the solution for this particular problem of mine.