Calculated field (Row based dataset)

[IAMDV]

Dear All,

I am newbie with Qlikview. I am using a personal edition. I have table of data which has 3 fields - RespID, QID, DATA

RespID QID DATA

1 M1 1

2 M1 2

3 M1 3

4 M2 1

5 M2 3

Now I need to calculate a score which should be for each QID (M1, M2, etc.) and the calculation method is

((COUNT(M1) = 1) * 3) + ((COUNT(M1) = 2) * 2) + ((COUNT(M1) = 1 * 1)

I hope this makes sense.... I need this asap. Thanks in anticipation.

Thanks,

DV

[#2]

Not sure to understand well.

Create a tab chart with

dimension : QID

expression = 4 - Count(distinct DATA) Maybe you dont't need the distinct, if you just want to count the numbers of rows

for M1 the score is 1

for M2 the score is 2

Hope it helps you

JJ

[IAMDV · Accepted solution]

Thank you JJ!

I hope you can help me with this...

Let's assume I have 1 Field in a table which has numeric values like 1, 2, 3, 4, 5

Score

1

2

1

1

3

1

2

3

4

5

4

5

And now I wanted to calculate the Weighted Mean score and the logic is...

=(((Count of 1) * 5) + ((Count of 2) * 4) + ((Count of 3) * 3) + ((Count of 4) * 2) + ((Count of 5) * 1) ) / Total Count

To make it more simple, I am attaching an excel file which contains the calculation. The idea is to show Weighted Mean score in charts for each department. I am sure this must be pretty simple to do...

Thanks again in anticipation.

Cheers - DV[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/3644.Example.xls:550:0]