topic Re: Will combining a Text field (URL Link) and a Dimension in a table be very expensive in Qlik? in App Development

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

daveviscountrxs — Thu, 16 Feb 2023 20:02:28 GMT

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!

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

rwunderlich — Sat, 18 Feb 2023 06:05:42 GMT

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

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

barnabyd — Sun, 19 Feb 2023 20:56:30 GMT

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.