Will combining a Text field (URL Link) and a Dimension in a table be very expensive in Qlik?

[daveviscountrxs]

Here is an example I would possible combine: 'https://websadmin.CompanyA.com/claims/' &  MemberID

I was told this is not a good idea because it will use a lot of resources.  The largest the table could be is a million records but will typically be much smaller.

Thanks!

[rwunderlich]

It may be relatively slow to render at a million rows. But if you are getting value from it, it may be acceptable. 

An alternative would be to place a show condition in this column to only show if one row is selected -- or some number of rows. 

-Rob

[barnabyd]

G'day @daveviscountrxs,

If you do this concatenation in the load script then you are moving some of the computational costs to a time when it won't affect the user experience. A million rows is always going to be slow for the user but the more you move to the load script the better it will be.

Cheers, Barnaby.