New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
New Contributor III

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.

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)

• Straight table and pivot table

1 Solution

Accepted Solutions MVP

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

May be this

Dimension

`Grade`

Expression

`Count([Material.No])`
13 Replies MVP

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

May be this

Dimension

`Grade`

Expression

`Count([Material.No])`
New Contributor III

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

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

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

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

New Contributor III

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

shall i directly call the below as you mentioned.
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 MVP

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

@saivina2920 wrote:
shall i directly call the below as you mentioned.
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

New Contributor III

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

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.. MVP

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

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

New Contributor III

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

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)... MVP

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

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