Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
markp201
Creator III
Creator III

Qlik Sense - custom expression or GUI?

Is there any performance gain with the following

MONEY(field,'$#,##0')

as opposed to using the GUI ?

2 Replies
ahaahaaha
Partner - Master
Partner - Master

Hi,

You can download several hundred thousand records, create UI a table with two variants of MONEY, click and see if the difference is noticeable.

Example script code

LOAD

RecNo() as ID,

Div(Rand()*10000,1) as Value

AutoGenerate 500000;

UI Table

Dimension: ID

Expression: Sum(Value)


To slow the switching, you can increase the number of lines AutoGenerate.

Regards,

Andrey

agigliotti
Partner - Master III
Partner - Master III

why you ask this?