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: 
JustinDallas
Specialist III
Specialist III

Expansion works in Master Measure, but not Master Dimension

Hello Folks,

I have a variable that I declare in my script:

SET vPayItemCodeTypes =

'BRKDWN','DET','FLAT','FUELMI','FULTRC',

    'GRNTPA','HDPAY','HOL','HR','LAYOVR','OT','RA-DED',

    'RA-ESC','RA-LOA','REFSIG','STP',

    'TRNPY','TSM','UNLD','VACHRL/PTO HR','TRLMOV',

    'SAFET','MINACC','INCNT1'

;

Then in a Master Measure, I have this and it works as expected.

SUM({<pyt_itemcode={$(vPayItemCodeTypes)}>} pyd_amount)

However, when I try the same thing in a Master Dimension, I have no such luck.

=if( match(pyt_itemcode, '$(vPayItemCodeTypes)', pyt_itemcode

, Null()

)

Nope.

=if( match(pyt_itemcode, $(vPayItemCodeTypes), pyt_itemcode

, Null()

)

No dice.

Does anyone know how I can get my variable to expand properly?

Any help is greatly appreciated.

1 Solution

Accepted Solutions
JustinDallas
Specialist III
Specialist III
Author

I'm an idiot.  I was lacking a closing parenthesis.


=if( match(pyt_itemcode, $(vPayItemCodeTypes)), pyt_itemcode  ,Null()  )

View solution in original post

1 Reply
JustinDallas
Specialist III
Specialist III
Author

I'm an idiot.  I was lacking a closing parenthesis.


=if( match(pyt_itemcode, $(vPayItemCodeTypes)), pyt_itemcode  ,Null()  )