topic Re: how can we group values? in QlikView

?

xyz1 — Sun, 14 Apr 2019 11:36:45 GMT

Re: how can we group values?

sunny_talwar — Thu, 02 Feb 2017 12:54:12 GMT

Are you using a crosstable load?

?

xyz1 — Sun, 14 Apr 2019 11:37:25 GMT

Re: how can we group values?

sunny_talwar — Thu, 02 Feb 2017 12:58:34 GMT

Why do you think they are wrong values? Would you be able to share your qvf if you have already created one for the sample data provided? It will save me time

?

xyz1 — Sun, 14 Apr 2019 12:41:39 GMT

Re: how can we group values?

sunny_talwar — Thu, 02 Feb 2017 13:12:06 GMT

I have already done that

Re: how can we group values?

sunny_talwar — Thu, 02 Feb 2017 14:11:25 GMT

Why do you think the numbers are wrong? Would you be able to share the correct numbers for this chart?

?

xyz1 — Sun, 14 Apr 2019 12:45:41 GMT

?

xyz1 — Sun, 14 Apr 2019 12:42:07 GMT

Re: how can we group values?

sunny_talwar — Thu, 02 Feb 2017 19:31:25 GMT

Little busy right now... but will surely check as soon as I get home

Re: how can we group values?

Anil_Babu_Samineni — Fri, 03 Feb 2017 04:39:38 GMT

Where is your qvf?

?

xyz1 — Sun, 14 Apr 2019 12:44:08 GMT

?

xyz1 — Sun, 14 Apr 2019 12:43:00 GMT

Re: how can we group values?

Anil_Babu_Samineni — Fri, 03 Feb 2017 06:06:36 GMT

Sorry, From here what was the error you faced? What you are expecting to see

Script is ok to me

And even Formula is fine for me

IF (Classification <= 0.25 , '0-25%' ,

IF (Classification >= 0.26 and Classification <= 0.50, '26-50%',

IF (Classification >= 0.51 and Classification <= 0.75, '51-75%',

IF (Classification >= 0.76 and Classification <= 1, '76-100%',

'Null'))))

?

xyz1 — Sun, 14 Apr 2019 12:43:32 GMT

?

xyz1 — Sun, 14 Apr 2019 11:39:13 GMT

Re: how can we group values?

jonathandienst — Fri, 03 Feb 2017 06:49:20 GMT

you might be hitting rounding problems which your bucket statement may not handle. i would simplify the statement (as well as make it more reliable). In load script:

If(Classification <= 0.25 , '0-25%' ,

If(Classification <= 0.50, '26-50%',

If(Classification <= 0.75, '51-75%', '76-100%'))) as Class

This assumes that call values of Classification are between 0 and 1.

?

xyz1 — Sun, 14 Apr 2019 11:38:31 GMT

Re: how can we group values?

jonathandienst — Fri, 03 Feb 2017 07:14:05 GMT

Is that your complete load script?

?

xyz1 — Sun, 14 Apr 2019 13:10:11 GMT