topic Re: Urgent: creating a scorecard in QlikView

Urgent: creating a scorecard

sayadutt — Tue, 19 May 2015 12:15:00 GMT

Hi Team,

I have a requirement where I need to publish a scorecard based on the values present in the fields. The values will be either Yes, No, Not Applicable or empty. OR received, Not Received, Not Applicable and empty.

Data file is attached.

Now the scorecard should calculate the percentage of Yes and assign marks:

Marks:

4: If Yes is more than 90%

3: If Yes is more than 60% and less than 90%

2: If Yes is more than 30% and less than 60%

1: If Yes is less than 30%

scorecard should look like this:

Division	Application	Test Case Sign Off	Test Case Present	Requirement Sign Off	Proj. timelines	Test Plan Sign Off Status	TOTAL SCORE
1	00	4	3	2	4	3	16
4	33	3	2	1	3	2	11
4	44	4	4	4	3	2	17

** scores given in the table are just numbers (not calculated)

Can you please help me in deriving this scorecard.

Thanks in advance

Re: Urgent: creating a scorecard

jpenuliar — Tue, 19 May 2015 12:25:25 GMT

The community may be able to help you quicker if you attach your qv app

Re: Urgent: creating a scorecard

sayadutt — Tue, 19 May 2015 12:28:45 GMT

Hi Jonathan,

I don't have any qv yet.

I uploaded the excel from where data will be loaded.

Thanks

Re: Urgent: creating a scorecard

manishnarang — Tue, 19 May 2015 13:13:01 GMT

Considering Division and Application as dimesions.

=count({$<[Project Timelines]={'Yes'}>} [Project Timelines]) / Count([Project Timelines])

This gives you the %age of Yes. you can make these variables and apply your score logic accordingly.

BTW, off topic, how do we copy and paste some code from QV here? I had to type every thing.

Re: Urgent: creating a scorecard

sayadutt — Tue, 19 May 2015 14:02:36 GMT

Hi manish,

can you please attach the qv file itself here.

It will help me to understand.

Thanks

Re: Urgent: creating a scorecard

sayadutt — Tue, 19 May 2015 19:49:30 GMT

Hi Team,

Can you please help me here.

Thanks

Re: Urgent: creating a scorecard

manishnarang — Wed, 20 May 2015 10:06:05 GMT

Check the attachment.

I have calculated “Yes %age for Project timelines”. You can formulate your logic of score over that like (if ($(=ProjTime) > 0.9 , 4, ……..) etc..