Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

INTERVALMATCH

Hi -

Can someone please help me with figuring out INTERVALMATCH issue that i am having when running QV script ( i am new to QV)

Step 1. I am using MDX statement to get Account infromaiton:

               Temp Table:

                         SELECT

                           { null } on 0,

                                 {DESCENDANTS([Account])}on 1   

                                   FROM [Cube];


Step 2. AND then i need to run intervalmatch formula that looks like this

               IntervalMatchTemp:

               INTERVALMATCH [Account] LOAD [GL Account Start], [GL Account End] RESIDENT Layout;

SCRIPT ERROR

Field is not Found

IntervalMatchTemp:

INTERVALMATCH {[([Account])} LOAD [GL Account Start], [GL Account End] RESIDENT Layout

Please help!

Thank you

11 Replies
Not applicable
Author

Hi,

Could you write " exit script " after the loading of PLTemp and then, take a screenshot of the Table Viewer in order to see what is the name of your field after the load ?

Amand Dupretz

Not applicable
Author

Start and End date are part of a different query. Which is work

PLTemp:

SELECT

  { null } on 0,

        ([Account].[H1].[LEV14])on 1

FROM [Cube];

IntervalMatchTemp:

INTERVALMATCH ("[Account].[H1].[LEV14]") LOAD [GL Account Start], [GL Account End] RESIDENT Layout;

IntervalMatch:

Load

distinct

("[Account].[H1].[LEV14]"),

[GL Account Start] & '|' & [GL Account End] as GLStartEnd

resident

IntervalMatchTemp;

drop table IntervalMatchTemp;

Drop table PLTemp;

Drop fields [GL Account Start], [GL Account End] from IntervalMatch;