topic Re: class editavel in QlikView

class editavel

qlik_ — Tue, 11 Nov 2014 19:42:08 GMT

Boa tarde

É possível tratar diferente uma informação que foi formata pela função CLASS

por exemplo, para trazer normalmente ele traz

0.00 a 30.00

mas eu quero trazer o valor a direita desta forma

0.00 a 29.99

quando edito e faço na formula a função - 0.01

ele apresenta desta forma

-0.01 a 29.99

Re: class editavel

maxgro — Tue, 11 Nov 2014 20:20:48 GMT

I think you can change the second number using the subfield function

=subfield((class(num(data),5,' ')),'<=',1) & ' To ' & text(subfield((class(num(data),5,' ')),' < ',2) -0.01)

Re: class editavel

MarcoWedel — Tue, 11 Nov 2014 21:00:51 GMT

Boa tarde carla,

one solution for this question could be:

Dual(Num(SubField(Class(value,30),' <= x < ',1),'R$ #.##0,00')&' - '&Num(SubField(Class(value,30),' <= x < ',2)-0.01,'R$ #.##0,00'),Class(value,30))

Due to the creation of dual values, you even don't have to care about sorting expressions:

LOAD *,
    Dual(Num(SubField(Class(value,30),' <= x < ',1),'R$ #.##0,00')&' - '&Num(SubField(Class(value,30),' <= x < ',2)-0.01,'R$ #.##0,00'),Class(value,30)) as class;
LOAD Round(Rand()*1100,0.01) as value
AutoGenerate 200;

hope this helps

regards

Marco

Re: class editavel

qlik_ — Wed, 12 Nov 2014 11:14:46 GMT

Thank you so much