topic Re: First sorted value based on expressions in QlikView

First sorted value based on expressions

venkatg6759 — Fri, 02 May 2014 16:03:01 GMT

Hi Everyone,

I have a table as shown in the attachment .

I have rating date and Author Name in dimensions and

Rating field has buy ,sell,neutral .................

where we count the # buy,# sell in expressions .

I need to get the most recent rating date for each of the rating count .

Any ideas on this ?

Thanks,

Venkata

giakoum — Fri, 02 May 2014 16:11:00 GMT

aggr(max([rating date]), [Author Name])

swuehl — Fri, 02 May 2014 16:11:59 GMT

Could you post a small sample QV app and your expected outcome (e.g. as Excel table or bitmap)?

venkatg6759 — Fri, 02 May 2014 16:30:27 GMT

I got what i need but how can i represent the same in a bar chart .

Check the attachment.

Thanks,

Venkata

msteedle — Sat, 03 May 2014 14:05:31 GMT

Represent what in a bar chart?

SunilChauhan — Sat, 03 May 2014 15:12:44 GMT

firstsortedvalue([rating date]), -[Author Name]

try this this

hope this helps