topic Re: CLASS function output adjust in QlikView

CLASS function output adjust

Wed, 19 Feb 2014 14:23:45 GMT

Hello,

The output of the Class function on my dashboard is like:

0 <= dias < 3

3 <= dias < 6

6 <= dias < 9

9 <= dias < 12

12 <= dias < 15

15 <= dias < 18

But i want the result like '0 ~ 3 dias'. I´ve tried to use the replace function, but the expression lost the sort order, anyone have any idea how could i replace this without loose the sort order?

Thanks!

Re: CLASS function output adjust

alexandros17 — Wed, 19 Feb 2014 14:26:01 GMT

I've not understood, please provide your example

Re: CLASS function output adjust

marcus_sommer — Wed, 19 Feb 2014 14:29:00 GMT

Change the sorting on expression with these class-function without replace().

- Marcus

Re: CLASS function output adjust

Wed, 19 Feb 2014 14:45:46 GMT

An example was attached! Use the slider to view the sort order in the legend ! Alessandro Saccone

Re: CLASS function output adjust

Wed, 19 Feb 2014 14:46:17 GMT

I've not understood!

Re: CLASS function output adjust

jerem1234 — Wed, 19 Feb 2014 14:54:33 GMT

Here are two ways:

1. Keep dimension the same, and use expression in sorting:

=only(CLASS(dias_aberto0, $(vStep)))

2. Use the dimension:

=dual(REPLACE(CLASS(dias_aberto0, $(vStep)), '<= x <','~') & ' dias', CLASS(dias_aberto0, $(vStep)))

and use sorting numeric - ascending

Please find attached.

Hope this helps!

Re: CLASS function output adjust

Anonymous — Wed, 19 Feb 2014 14:56:26 GMT

Attached is the correct solution.

=DUAL(REPLACE(CLASS(dias_aberto0, $(vStep)), '<= x <','~')& ' dias',CLASS(dias_aberto0, $(vStep)))

sort by number then ascending

Re: CLASS function output adjust

MK_QSL — Wed, 19 Feb 2014 14:58:30 GMT

Try like below...

=DUAL(REPLACE(CLASS(dias_aberto0, $(vStep)), '<= x <','~') & ' dias',CLASS(dias_aberto0, $(vStep)))

Once you use Replace function, the output of Class function convert from Number Format to Text Format.

Re: CLASS function output adjust

Wed, 19 Feb 2014 14:59:07 GMT

Thank you so much!

Re: CLASS function output adjust

Wed, 19 Feb 2014 15:03:17 GMT

Thanks, i'll remember that!