Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Could you post a sample qvf file to better understand what are you doing with that expression?
Regards
Andrea
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
I'd need more details about your request, else I can't help you.