topic Re: Qlikview Expression in QlikView

Qlikview Expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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....

Re: Qlikview Expression

migueldelval — Wed, 01 Feb 2017 14:26:12 GMT

Hi Siva,

Check this example please.

Regards

Miguel del Valle

Re: Qlikview Expression

Anonymous — Wed, 01 Feb 2017 14:29:14 GMT

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.

Re: Qlikview Expression

migueldelval — Wed, 01 Feb 2017 14:41:19 GMT

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

Re: Qlikview Expression

Anonymous — Wed, 01 Feb 2017 14:51:00 GMT

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...

Re: Qlikview Expression

migueldelval — Wed, 01 Feb 2017 15:33:55 GMT

Hi Siva,

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

Could you attach an qvw example?

Regards

Miguel del Valle

Re: Qlikview Expression

Anonymous — Wed, 01 Feb 2017 15:53:39 GMT

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.

Re: Qlikview Expression

Anonymous — Wed, 01 Feb 2017 15:54:14 GMT

Plz take the QVW file from my original post

Re: Qlikview Expression

migueldelval — Wed, 01 Feb 2017 16:14:59 GMT

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

Re: Qlikview Expression

Anonymous — Thu, 02 Feb 2017 05:36:36 GMT

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.