Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

Re: How do I do the following...

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
Highlighted
Not applicable

Re: How do I do the following...

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: How do I do the following...

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


talk is cheap, supply exceeds demand
Highlighted
Not applicable

Re: How do I do the following...

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: How do I do the following...