Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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
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

What do you want the output to look like?

Creator
Creator

Excellent Ji......