topic Re: How to Compare two Fields in same Chart in QlikView

How to Compare two Fields in same Chart

Wed, 20 Jan 2016 17:10:19 GMT

Hi,

how to compare two fields ie.

in my senario i need to compare Developer and Manager Contribution in single chart or in any chart just show side by side and value on data points !

Re: How to Compare two Fields in same Chart

Wed, 20 Jan 2016 17:12:35 GMT

You can create Bar chart with Dimension and two expressions.

first expression: Developer Contribution

second expression: Manager Contribution.

Re: How to Compare two Fields in same Chart

Wed, 20 Jan 2016 17:14:44 GMT

Use this dimension:

IF(IsNull(Manager), Developers, Manager)

Re: How to Compare two Fields in same Chart

Gysbert_Wassenaar — Wed, 20 Jan 2016 17:18:10 GMT

There are several ways you can do this. The easy way out is to use a calculated dimension: =[Manager] & [Developers]. You can add a background color expression to the expression to give the manager bar a different color: =if(Len(Manager), lightred())

Re: How to Compare two Fields in same Chart

israelcsouza — Wed, 20 Jan 2016 17:46:23 GMT

Follows the attachment,

Re: How to Compare two Fields in same Chart

Wed, 20 Jan 2016 17:59:17 GMT

thanks Gysbert.

i got it.but in my sourse file i got 50 managers names and their team members.

when select a manager name then his team membs contribution and his contribution should show .but in my case it showing only manager name dosnt showing developer names and by default it should show only one manager name when no selections made.

Re: How to Compare two Fields in same Chart

Wed, 20 Jan 2016 18:02:04 GMT

thanks israel,

when i select manager it should show all developers names along with Manager contribution it like comparision side by side

Re: How to Compare two Fields in same Chart

Wed, 20 Jan 2016 18:11:22 GMT

the problem is your data, some developers doesn't have a Manager.

Manager	Developers	Contribution
Sam		1000
Nile	leno	200
Mick	Falts	399
	Afstla	500
	Antony	600
	bent	400
	brigate	788
	cult	820
	David	300
	Frank	500
	jon	400
	mark	300
	Mickle	700
	samule	599
	venil	987
	William	200
	Wilson	900

Re: How to Compare two Fields in same Chart

Gysbert_Wassenaar — Wed, 20 Jan 2016 18:26:15 GMT

Ok, then transform your table like this:

Manager, Employee, Role, Contribution:

Sam, Sam, Manager, 1000

Sam, Anthony, Developer, 600

Sam, David, Developer, 300

...etc

Mick, Mick, Manager, 900

Mick, Frank, Developer, 500

Mick, Eva, Developer, 400

...etc

Then use Employee as dimension in the chart and use the field Manager to select a manager.

Re: How to Compare two Fields in same Chart

israelcsouza — Wed, 20 Jan 2016 18:26:41 GMT

ok,

and now?

Re: How to Compare two Fields in same Chart

Wed, 20 Jan 2016 18:34:04 GMT

i changed th data still it continues .now manager names and developers names are combined when i select

Re: How to Compare two Fields in same Chart

Wed, 20 Jan 2016 19:54:52 GMT