How to combine different work week across multiple measures

[Anonymous]

Hi,

I need to combine different weeks dimension across multiple measure.

For example - I use CR_BKLG_WEEK for CR Backlog $, RS_BKLG_WEEK for RS Backlog $ and Invoice Week for POS and Shipment. Can you help me to create an expression? I started on this below expressions but it didn't work out.

IF(DBF_ALL_MASTER_QTR=$(vThisQTR),RIGHT(INVOICE_WEEK,4),

IF(CR_BKLG_QTR=$(vThisQTR),RIGHT(CR_BKLG_WEEK,4),

IF(RS_BKLG_QTR=$(vThisQTR),RIGHT(RS_BKLG_WEEK,4))))

Thanks

[agigliotti]

Hi,

Could you post a sample qvf file to better understand what are you doing with that expression?

Regards

Andrea

[Anonymous]

Hi Andrea,

Thanks for your response.

Sorry, I wasn't able to create qvd file as I only have an access in Visualization.

I don't have an access in data model.

Can you refer on my sample below?

Thanks,

Martel

[agigliotti]

I'd need more details about your request, else I can't help you.