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

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

saivina2920 — Sat, 16 Nov 2024 04:14:19 GMT

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

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

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

sunny_talwar — Fri, 08 Mar 2019 01:57:16 GMT

May be this

Dimension

Grade

Expression

Count([Material.No])

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

saivina2920 — Fri, 08 Mar 2019 04:26:20 GMT

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

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

sunny_talwar — Fri, 08 Mar 2019 11:56:29 GMT

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

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

saivina2920 — Fri, 08 Mar 2019 12:01:38 GMT

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

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

sunny_talwar — Fri, 08 Mar 2019 12:03:02 GMT

@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

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

saivina2920 — Fri, 08 Mar 2019 12:34:17 GMT

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

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

sunny_talwar — Fri, 08 Mar 2019 12:37:09 GMT

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

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

saivina2920 — Fri, 08 Mar 2019 12:50:08 GMT

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

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

sunny_talwar — Fri, 08 Mar 2019 12:52:15 GMT

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

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

saivina2920 — Fri, 08 Mar 2019 13:12:58 GMT

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

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

saivina2920 — Fri, 08 Mar 2019 13:15:54 GMT

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

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

sunny_talwar — Fri, 08 Mar 2019 13:37:22 GMT

What do you want the output to look like?

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

saivina2920 — Wed, 13 Mar 2019 10:42:19 GMT

Excellent Ji......