Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I do the following...

...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.QVQuestion.bmp

5 Replies
Gysbert_Wassenaar

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]))


talk is cheap, supply exceeds demand
Not applicable
Author

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

Gysbert_Wassenaar

Yes, that error makes sense if you use it as a calculated dimension instead of as an expression.


talk is cheap, supply exceeds demand
Not applicable
Author

My bad....I've moved it from a dimension and plugged as an expression, it's returning a blank for everything though.