Qlikview Expression

[Anonymous]

Guys,

I have provided some sample data as in the table and I have attached the real data with this.

MonthName	EmpFullName	WorkHours
Jul 2010	Sathish Dhanapalan	0
Jul 2010	Siva Thangavel	10
Jul 2010	Arvinthakash Nagamani	8
Sep 2010	Mohanraj Vellaichamy	7
Sep 2010	Shabarish	9

With this data, I want to create a bar chart with three bars showing each one for Occupied, Partially occupied and Available as below,

The conditions for Occupied - Workhours >=8, Partially Occupied - Workhours >3 and <8 and for available - Workhours <4

and also I have a master calendar for months and Years for this bar chart. It should also satisfy the below conditions,

1. Selecting only one Year or more than one year in the master calendar.

2.Selecting only one Month or more than one Month in the master calendar.

3.Selecting Both months and years more than one at the same time.

Plz help me out guys....

[migueldelval]

Hi Siva,

Check this example please.

Regards

Miguel del Valle

[Anonymous]

Thanks Miguel, But I couldn't open this QVW file because of using QV desktop version. So could you please elaborate in detail what I need to do for this.

[migueldelval]

Hi Siva,

Dimmension:

=IF( WorksHours>=8, 'Occupied',  IF(  WorksHours>3 and WorksHours<8,  'Partielly Occupied',  IF( WorksHours<=4,  'Available WorkHours',  )))

Expression:

=count(EmpFullName)

And look like this:

Regards

Miguel del Valle

[Anonymous]

Thanks Miguel, the bar chart is working fine. But when I select multiple months and years the data is not shown accordingly (Mismatching). How can we adjust this for Master calendar? Plz help...

[migueldelval]

Hi Siva,

Mi Example it´s work fine with multiple months and years.

Could you attach an qvw example?

Regards

Miguel del Valle

[Anonymous]

Miguel, I have attached the QVW file. In this file, I need the resource allocation and utilization level count same when I select multiple months and years for each occupied, available and Partially occupied count.

[Anonymous]

Plz take the QVW file from my original post

[migueldelval]

Hi Siva,

I think that your error it´s in you dimension. You are counting same employee in two segments, for example test Mohan... Vel.... in 2014.

May be you need to redefine your requirement ot explain it a little bit.

Regards

Miguel del Valle

[Anonymous]

Thanks Miguel,

I'm showing employee count based on occupied, partially occupied and available in two representations. one is resource allocation (In Text object, I've shown the count) and the other one is bar chart. In these both representations, the count should be same when I selected months or years.