topic Re: Use Table Column in a formula in QlikView

Use Table Column in a formula

asalamun — Thu, 05 Oct 2017 18:20:28 GMT

I have my list of holidays as a column in an excel file, how do I call this table column as my holiday list inside of the Networkdays() formula?

marcus_sommer — Fri, 06 Oct 2017 11:27:58 GMT

You could use a $-sign expansion for it, like:

networkdays(Date1, Date2, '$(=concat(Holidays, chr(39) & ',' & chr(39)))')

- Marcus

sunny_talwar — Fri, 06 Oct 2017 11:34:46 GMT

May be look here:

asalamun — Fri, 06 Oct 2017 12:36:39 GMT

I'm trying to use it within my load statement to get a NetWorkDays field

Here is what my holidays data looks like.

marcus_sommer — Fri, 06 Oct 2017 18:22:46 GMT

Take a look on the link provided from Sunny which applied the concat-logic within the script.

- Marcus