topic Re: Separator for custom expression in QlikView

Separator for custom expression

Mon, 17 Oct 2016 13:43:36 GMT

Hi all,

I am using the following expression in a text object to display the value. I want to separate as millions thousands hundreds (basically thousand separator) .

=NUM(count( { < Year={$(=varCurrYear)} , type= {'A','B'}> } type ))

TIA,

Re: Separator for custom expression

sunny_talwar — Mon, 17 Oct 2016 13:52:15 GMT

May be this:

=Num(Count({<Year = {$(=varCurrYear)}, type= {'A','B'}>} type), '#,##0.0')

Re: Separator for custom expression

Mon, 17 Oct 2016 13:55:57 GMT

try this .....

=NUM(count( { < Year={$(=varCurrYear)} , type= {'A','B'}> } type ),'#,###')

Mark this helpful/correct answer as applicable please.

Re: Separator for custom expression

Tue, 18 Oct 2016 07:34:03 GMT

Thanks for your reply. I forgot to add something in my actual thread.

If the result is 200743 it should be displayed as 2 00 743

If the result is 123456.87 it should be displayed as 1 23 456,87

If the result is 98765432109.03 it should be displayed as 98 76 54 32 109,03

Please advise an expression for this.

Re: Separator for custom expression

sunny_talwar — Tue, 18 Oct 2016 09:46:23 GMT

Try this:

=Num('98765432109.03', '## ## ## ## ##0,00', ',', ' ')

And this for your expression:

=Num(Count({<Year = {$(=varCurrYear)}, type= {'A','B'}>} type), '## ## ## ## ##0,00', ',', ' ')

Re: Separator for custom expression

Tue, 18 Oct 2016 10:02:22 GMT

I am getting error in expression How to search on this topic ? I want different separator for different text objects in my dashboard. Please help me with a link that provides all these.

-J

Re: Separator for custom expression

sunny_talwar — Tue, 18 Oct 2016 10:04:20 GMT

What is the error you are getting? Have you tried the hard-coded expression in a text box object?

Re: Separator for custom expression

Tue, 18 Oct 2016 10:06:18 GMT

Sorry ! I missed the comma next to the number

Thanks Sunny !