Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

How do we convert as column count from by row data using Chart-Straight table

I have SQL table and it contains millions of records. I just want to get count of every gropy by values dynamically..

This i want using Chart-Straight Table.

For example, let us consider below is my table example.

Material.No           Grade

101                            A

102                           B

103                           C

101                           C

101                           A

110                          D

110                           A

104                          F

103                          M

etc.....                    .....

 

Final output would be and group by grade. so the count as below

          B          C        D        F         M

3            1           2        1         1          1

Note : The output will be always dynamic. some times it may add some more values. so want to get that count also.

pls. guide us how to get the count in Chart - Staright Table. This is important in my module and reply asap.

     

 

Labels (2)
13 Replies
Highlighted
Creator
Creator

pls. find below sample data.

MATERIAL NO STATUS
101 A Grade
101
101 A Grade
102 B Grade
102 A Grade
102 A Grade
102
102
103 A Grade
103 C Grade
103 D Grade
103
103 E Grade
Highlighted
Creator
Creator

Pls. find sample data...

MATERIAL NO STATUS
101 A Grade
101 NULL
101 A Grade
102 B Grade
102 A Grade
102 A Grade
102 NULL
102 NULL
103 A Grade
103 C Grade
103 D Grade
103 NULL
103 E Grade
Highlighted

What do you want the output to look like?

Highlighted
Creator
Creator

Excellent Ji......