Create Straight Table

[#1]

Hi All,

I have the following data,Based on this data can we prepare Straight table like this

My Data:-

Empid    Grade    Subject  Score

1001        A          English    76

1001        A          Matha      52

1001        A          Science  38

1102        B          English    34

1102        B          Matha      55

1102        B          Science      36

1002        B          English    54

1002        B          Matha      35

1002        B          Science      40

1101        A          English    86

1101        A          Matha      42

1101        A          Science  58

Output:

Grade    Score_Status    Average_Score    Employee_Count

A            Y                    59.1                      2

B            N                    42.3                      2

--I want to Grade,Score_Status are Dimensions and Average_Score,Employee_Count are Expression.

Here Score_Status is if(avg(Score)<=50,'N','Y'))

Regards

Sharath

[petter]

=Num(Aggr( Avg(Score) , Empid ) , '0.0%','.',',')

[qlikviewwizard]

Hi Sharath,

Please follow Neetha_p solution. It works.