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
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. 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)
1 Solution

Accepted Solutions

May be this

Dimension

Grade

Expression

Count([Material.No])

View solution in original post

13 Replies

May be this

Dimension

Grade

Expression

Count([Material.No])

View solution in original post

Creator
Creator

can i have sample page with example complete Scripts...

sample script? I am not sure I understand? Do you have an app where you are trying this? May be share that and we can update it to show how this can be done

Creator
Creator

Thanks for your help..
shall i directly call the below as you mentioned.
Dimension : Grade
Expression : Count([Material.No])
if i set the above expression, can i get the below report.
A B C D F M

3 1 2 1 1 1


@saivina2920 wrote:
Thanks for your help..
shall i directly call the below as you mentioned.
Dimension : Grade
Expression : Count([Material.No])
if i set the above expression, can i get the below report.
A B C D F M

3 1 2 1 1 1

I believe so

Creator
Creator

I tried. but, i will show as row wise..like below.
A : 3
B : 1
C : 2
😧 1

etc....

But, i want horizontal wise not vertical wise..

On the presentation tab, check 'Horizontal' to make it horizontal 🙂

Creator
Creator

Thanks., i already found..even though great help...kudos...
My grade some values are blank and should not consider the value.
How to exclude the blank value in the grade (dimensions)...

Not sure I understand your question? Can you elaborate using an image?