topic Re: Pivot chart expression in QlikView

Pivot chart expression

Mon, 24 Sep 2012 08:42:15 GMT

Hi,

Consider the following scenario:

1. Candidate can solicitate to one or more companies

2. Each company has its own set of compliancies (criterias) the candidate needs to be checked upon.

Fact table would look something like this

CandidateId	Company	CompliancyID	Compliant Date
1	A	1	15-5-2012
1	A	2	27-5-2012
1	A	3	31-5-2012
1	A	4	15-6-2012
2	A	1	27-6-2012
3	B	4	31-8-2012

the challenge:

show in Pivot chart, per candidate, show all compliancies with a V mark if the candidate was compliant and X if not

if date 1-9-2012 was selected:

CandidateId	Company	Has ID	Has Bachellor degree	IQ score higher than 100	No criminal record
1	A	v	v	v	v
2	A	v	x	x	x
3	B				v

if date 31-5-2012 was selected:

CandidateId	Company	Has ID	Has Bachellor degree	IQ score higher than 100	No criminal record
1	A	v	v	v	x
2	A	x	x	x	x
3	B				x

RedSky001 — Mon, 24 Sep 2012 11:18:39 GMT

The attached qvw seems to do exactly what you have proposed it should do in the two senarios.

Am I missing something?

Mark

Tue, 25 Sep 2012 08:15:37 GMT

Almost. If you select Kate you will see only one compliancy. I would like to see here ALL compliancies which are bounded to Google.

Tue, 25 Sep 2012 09:48:24 GMT

solved it in the script, by creating an empty record for each non-filled compliancy. Ugly, but works.