topic Re: Grouping in QlikView

Grouping

tracycrown — Fri, 19 Feb 2021 11:47:32 GMT

Dear all

Kindly advise the solution for the issues below:

Q1. Why 10 is in Range 1-2 of column 2 & 9 is missing ?
Q2. Why total number in column 3 cannot be computed ?.

Correct Answer :

Thank you so much, Tracy

edwin — Fri, 19 Feb 2021 12:22:17 GMT

its because Grade is loaded as text. there are a couple of ways to address this:
use

=if(num#(Grade)>=Lower and num#(Grade)<=Upper,Grade)

or during load

load num#(Grade) as Grade, ...

edwin — Fri, 19 Feb 2021 12:23:02 GMT

or you can fix your original data source, maybe it is configured as text or there's a space or something

tracycrown — Fri, 19 Feb 2021 15:27:19 GMT

Dear Edwin

Thank you so much for your quick response and best advice. I tried to modify it at source but it does not work, please advise ?.

CrossTable(num#(Grade), AData)
LOAD * FROM
[Test-1.xlsx]
(ooxml, embedded labels, table is Analysis);

Thank you very much, Tracy

edwin — Fri, 19 Feb 2021 15:32:06 GMT

as i said you can address this in load script, add the conversion

num#(Grade) as Grade

edwin — Fri, 19 Feb 2021 15:32:37 GMT

you will of course enumerate your fields and not use *

tracycrown — Sat, 20 Feb 2021 02:11:41 GMT

Thank you very much for your kind advice.