topic Complex Dimension Value Calculation in QlikView

Complex Dimension Value Calculation

tresB — Tue, 30 Nov 2010 18:30:59 GMT

Hi All,

Here is my issue:

For Sample data, find the attachement. Please help me out.

Thanks and regards,

tresesco

Complex Dimension Value Calculation

pover — Tue, 30 Nov 2010 19:05:36 GMT

Try something like the following dimension:

=aggr(max({$<Date={"<=$(vMaxDate)"}>} Date),ID)

Regards.

Complex Dimension Value Calculation

tresB — Tue, 30 Nov 2010 19:22:54 GMT

Thanks Pover, for your response. i have tried the similar in expression(not in dimension...because in dimension set analysis probably does not work). using this i get the ID wise MAX DATE, but i need to compare the STATUS corresponding to that MAXDATE....that's the area where i am getting stuck. please have a look, if you can help me out.

Thanks.

Complex Dimension Value Calculation

pover — Tue, 30 Nov 2010 21:49:33 GMT

Take a look at the example. I think that is what you are looking for.

Regards.

Complex Dimension Value Calculation

tresB — Fri, 03 Dec 2010 07:38:35 GMT

Thanks Karl,

Though this was not the proper solution i wanted, still your SET gave me the clue to the solution.

Thanks a lot.

Regards,

tresesco