topic Re: Max count comparison on year /previous year in QlikView

Max count comparison on year /previous year

Qlik__Vinodh — Thu, 17 Jan 2013 11:51:01 GMT

Dear all,

I am having one problem,that is

1. I am having 5 years data now,if i click a year in dashboard, i need current year max employee count Month data and previous year max employee count month data in bar chart .

2. dimension is month, and Expression is Count(distint Emp_Id).

3. any one having sample application for same soluation ,share me.

if any one knows the soluation.pls help me.

Thanks,

c vr

Re: Max count comparison on year /previous year

Thu, 17 Jan 2013 12:06:52 GMT

Hi,

You can use a bar chart with Year as dimension and expressions as:

1. =count({<Year={$(vLastYear)}>}distinct Employee)

where vLastYear is a variable defined as:

=Year(Today())-1

2. =count({<Year={$(vCurrentYear)}>}distinct Employee)

where vCurrentYear is a variable defined as:

=Year(Today())

Please find the sample attached.

Is that what you are looking for?

Regards,

-Khaled.

Re: Max count comparison on year /previous year

Qlik__Vinodh — Thu, 17 Jan 2013 12:14:51 GMT

This is ok,but i need the max of employee count in current year and previous year. it mean which month having the top employees count in current year and previous year. this comparison is required.help me

Re: Max count comparison on year /previous year

Thu, 17 Jan 2013 12:17:16 GMT

Hi,

Just noticed that you need the value for year selected by user and its previous year.

Here's the updated QVW.

For this implementation:

1. Define a variable named vSelectedYear

with definition =GetFieldSelections(Year)

2. Define another variable named vPreviousYear

with definition =GetFieldSelections(Year)

and add these expressions in the bar chart:

1. =sum({<Year={$(vSelectedYear)}>}Value)

2. =sum({<Year={$(vPreviousYear)}>}Value)

Please find the QVW attached.

Hope that helps.

Regards,

-Khaled.

Re: Max count comparison on year /previous year

Qlik__Vinodh — Thu, 17 Jan 2013 12:22:32 GMT

ok,but i need Max of count in current yearmonth and max of count in previous yearmonth

Re: Max count comparison on year /previous year

Qlik__Vinodh — Thu, 17 Jan 2013 12:24:06 GMT

ok,but i need Max of count in current yearmonth and max of count in previous yearmonth

it means which month having the highest count in current year and previous year is required.help me

Re: Max count comparison on year /previous year

jagan — Thu, 17 Jan 2013 12:38:03 GMT

HI,

Can you attach the sample file.

Regards,

Jagan.

Re: Max count comparison on year /previous year

Qlik__Vinodh — Thu, 17 Jan 2013 12:40:36 GMT

hi,

i need one sample application for what i am asking u friend.

Re: Max count comparison on year /previous year

Qlik__Vinodh — Thu, 17 Jan 2013 12:48:18 GMT

Hi all,

i need the current year month and previous year month comparison ,but this months should be highest values in that years, when user selecting one year.

Re: Max count comparison on year /previous year

Thu, 17 Jan 2013 13:43:13 GMT

Hi,

Try this:

=sum({<Month={$(=Max(Month))},Year={$(vSelectedYear)}>} Value ) --- for the Current Selected Year

=sum( {$<Month = {$(=Max(Month)-1)},Year={$(vPreviousYear)}>} Value ) -- for the previous year

This should always use the max month to calculate the value.

Hope that helps.

Regards,

-Khaled.

Re: Max count comparison on year /previous year

Qlik__Vinodh — Fri, 18 Jan 2013 09:38:58 GMT

Hi ,

If any one knows soluation pls help me

Re: Max count comparison on year /previous year

Qlik__Vinodh — Fri, 18 Jan 2013 09:53:02 GMT

Hi ,

If any one knows soluation pls help me

Re: Max count comparison on year /previous year

Fri, 18 Jan 2013 16:25:21 GMT

Hi,

You can try the following steps to get this done:

To begin with, define three variables

1. vSelectedYear

Definition: =GetCurrentField(Year)

2. vPreviousYear

Definition: = (GetCurrentField(Year)-1)

3. vMaxx_Month

Definition: =MaxString({<Year={$(vSelectedYear)}>}Month)

Now, create a bar chart and add the following expressions:

1. For Selected Year:

=count({<Year={$(vSelectedYear)},Month={$(vMaxx_Month)}>}EmployeeID)

2. For Previous Year:

=count({<Year={$(vPreviousYear)},Month={$(vMaxx_Month)}>}EmployeeID)

Please find sample attached.

Hope it helps

Regards,

-Khaled.

Re: Max count comparison on year /previous year

Qlik__Vinodh — Mon, 21 Jan 2013 05:46:54 GMT

Hi Khaled,

Thanks for your reply.u r showing the always selecting the Max month in current year and previous year.it is ok.but i need the selected year highest count month and previous year highest count month comparison .

The value of count should be High value in current year and previous year. if have any soluation help me.

Thanks&Regards,

c vr