topic Re: Replace in Calculated Dimension in QlikView

Replace in Calculated Dimension

byrnel0586 — Thu, 14 Jun 2018 16:09:58 GMT

Hi all,

I am attempting to replace some text in a field using a calculated dimension and am getting an error. I was doing this in the script previously, but there can be multiple EVENT_DATES and I only want to show the max of them in the message. The expression will work in a text object. I have also attached a screenshot. Any help is appreciated!

=Replace(Replace(FinalMessage1,'Date1',max({<MeasureID>}EVENT_DATE)),'Date2',max({<MeasureID>}DUE_DATE))

Re: Replace in Calculated Dimension

sunny_talwar — Thu, 14 Jun 2018 16:38:55 GMT

Try this

=Replace(Replace(FinalMessage1, 'Date1', Max(TOTAL {<MeasureID>} EVENT_DATE)), 'Date2', Max(TOTAL {<MeasureID>} DUE_DATE))

Re: Replace in Calculated Dimension

byrnel0586 — Thu, 14 Jun 2018 17:32:55 GMT

Thank you!!!