Is it possible to dynamically load date headings?

SGood — Tue, 05 Apr 2022 16:45:32 GMT

I have a table containing multiple columns, many of which the names do not change (are static). The table contains columns headed as month and year. These headings will change throughout the year, previous months will drop in the data and new months will be added.

Example data (my table actually contains a lot more fields):

Active Project?

Project Manager ID

Project Manager Name

Billable Project?

Name

Priority

Feb-21

Mar-21

Apr-21

May-21

Jun-21

Jul-21

Aug-21

Sep-21

Oct-21

Nov-21

Dec-21

Jan-22

Feb-22

Mar-22

Yes

123456

Bloggs, Fred

Yes

904797

Project Name

SCP only

0.00

17.00

21.00

0.00

I would like to be able to load these "month-year" fields dynamically, in QlikView, so I don't have to amend the script every time old months are dropped and new months are added. Is this possible? Any help would be greatly appreciated. Thanks in advance.

Re: Is it possible to dynamically load date headings?

rwunderlich — Tue, 05 Apr 2022 16:59:54 GMT

Take a look at the "Crosstable" load prefix. In your case

Crosstable (Month, Value, 7) Load ...

See https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/crosstable.htm

-Rob

Re: Is it possible to dynamically load date headings?

SGood — Wed, 27 Apr 2022 07:09:46 GMT

Thanks Rwunderlich. That works perfectly.

topic Re: Is it possible to dynamically load date headings? in QlikView

Is it possible to dynamically load date headings?

Re: Is it possible to dynamically load date headings?

Re: Is it possible to dynamically load date headings?