topic Re: How do I do the following... in QlikView

How do I do the following...

Tue, 08 Jul 2014 10:03:34 GMT

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

Re: How do I do the following...

Gysbert_Wassenaar — Tue, 08 Jul 2014 10:10:21 GMT

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

Re: How do I do the following...

Tue, 08 Jul 2014 10:45:37 GMT

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

Re: How do I do the following...

Gysbert_Wassenaar — Tue, 08 Jul 2014 10:49:12 GMT

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

Re: How do I do the following...

Tue, 08 Jul 2014 10:53:02 GMT

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

Re: How do I do the following...

Gysbert_Wassenaar — Tue, 08 Jul 2014 11:01:00 GMT

Maybe these documents help:

QlikCommunity Tip: How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling