varies from type

[Anonymous]

Hi

I have two tables

please please request help

attached is the sample qvw.

[Anonymous]

any kind of support

[sunny_talwar]

You have made certain selections in your app already. the right chart shows 74 for Contract when I have Employment Type CONTRACT selected,

but shows 72 when I select PERMANENT

I think there is some bigger data model issue or something related to your expression that isn't working the way you want it to work. I think we will need to get to the very basics and know if 74 is actually the right number and how exactly you came up with it ( What was the logic)?

[Anonymous]

Hello Sunny

Thanks for the analysis

the expression is only the requirement

and the logic is no of employees joined year , and the age wise but the employees age wise and the ytd employees should be the same but some where we need to use sort key

but not sure how to use it though

pls help me on this i know till this requirment i dnt know much i need the figure to be 74 that matches to the other chart

[omerfaruk]

Your aggr function produces 3 values. 1 is unknown, is this the desired result ? I advise you to revise it once again.

Another thing,

Based on your calendar script, in year 2015,there are

280 employees,

106 contractors,

187 Permanent employee.

Contractors and permanent sum is not equal to total employees. 293 - 280.

Is there any duplicate somewhere in your data ?

[Anonymous]

Thanks Omer Demir for your analysis too.

the same thing i was also trying to figure out ...

but i hope there is no distinct values and need to customize the expression some how

i was finidng it way difficult to match these two tables contract emp numbers

need help even i am also working out on expression .

could you look into [(h)Sort Key] i.e max([(h)Sort Key]) which gives the latest record or date for the employees

i am trying  to apply the sort key logic in the expression but of no use

[Anonymous]

any other suggestions?

[sfatoux72 · Accepted solution]

Hi John,

On table "YTD No. of Employees by Employment Type as at 2015" you use a calculated dimension that you named "Staff Employment Type", but in reality it is "Last Staff Employment Type".

The other table depends of the selection of "Staff Employment Type". But during the year people of Staff could have different "Staff Employment Type".

A good solution will be to create a dimension "Last Staff Employment Type" during the data load and use it instead :

- the dimension field "Staff Employment Type"

- the calculated dimension on table "YTD No. of Employees by Employment Type as at 2015"

Regards

[Anonymous]

Hello Sebastien

thanks alot for your analysis

confused a bit and could you please share me sample expression to write or app ?

could you please respond?

[Anonymous]

Hello any suggestions