Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

grakeshqvd
New Contributor III

How to calculate Totals and Top5 totals in single stacked bar chart expression

Hi, 

We need to calculate Count of Totals and Count of Top5 totals in single stacked bar chart(Set Analysis).

Calculate Count of "EmployeeName"where the "EmployeeIssues" not equals to 'FAIL' and 'NULL'.

Need to write the expression for both - Total and Top5 total count in single bar chart.

 

Regards,

Rakesh

4 Replies

Re: How to calculate Totals and Top5 totals in single stacked bar chart expression

Hi,

Can you share sample data along with expected output.

 

Regards,

Kaushik Solanki

grakeshqvd
New Contributor III

Re: How to calculate Totals and Top5 totals in single stacked bar chart expression

HI Kaushik,

Please find sample data. For EmployeeName-AAA, need to calcualte EmployeeName"where the "EmployeeIssues" not equals to 'FAIL' and 'NULL'. Like the way same for other Employess also. 

Expected Output:

We need to show in the stacked Combo chart Month wise,

Where Totals and Top5 Totals bars  for each month.

Totals(Bar):  EmployeeName"where the "EmployeeIssues" not equals to 'FAIL' and 'NULL'.

Top5 Totals(Bar): only Take Top5 totals from Totals

Top 5% Totals(Line): Top5 Totals/Totals.

 

Thanks,

Rakesh

 

 

Regards,

Rakesh

 

Re: How to calculate Totals and Top5 totals in single stacked bar chart expression

Hi,

On what basis you want to find the Top.

Also do you want to just count distinct employee or you want to count the transactions with filter condition i.e (Not equal to Null or Fail)?

 

Regards,

Kaushik Solanki

grakeshqvd
New Contributor III

Re: How to calculate Totals and Top5 totals in single stacked bar chart expression

Need totals for Month wise.

No distinct, 

want to count the transactions with filter condition i.e (Not equal to Null or Fail).

 

Regards,

Rakesh