Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
...how can I get the result of two calculated dimensions onto the same line?
I have the following calculated dimensions;
ThisMonth =If(GoldMonth=[This Month Num],[Employer RAG])
LastMonth =if(GoldMonth=[This Month Num]-1,[Employer RAG])
They work and return the result that I'm after, the only issue they are on separate lines so it looks like the data is duplicated (see attached picture). I'd ideally like the result of each to be on the same line, I just can't get the correct syntax.
Perhaps by removing the GoldMonth dimension and using this expression:
=maxstring(aggr(If(GoldMonth=[This Month Num],[Employer RAG]),[Client Name],[Employer Owner],[Exec Sponsor],
[Advisor]))
I was thinking along the same line as using the AGGR function, I couldn't get it to work though. Unfortunately, this isn't working either, it returns an 'Error in calculated dimension' message
Yes, that error makes sense if you use it as a calculated dimension instead of as an expression.
My bad....I've moved it from a dimension and plugged as an expression, it's returning a blank for everything though.
Maybe these documents help:
QlikCommunity Tip: How to get answers to your post?
Preparing examples for Upload - Reduction and Data Scrambling