topic Re: Need help with Max date and sum set expression in QlikView

Need help with Max date and sum set expression

Wed, 02 Dec 2015 21:58:11 GMT

Name: Sale Date QTY

X 10/01/15 5

X 11/01/15 10

X 12/01/15 15

Y 10/01/15 5

Y 11/01/15 10

Y 12/01/15 15

How do I get to a set expression of below result:

Name: Max Date of Sale Date Total QTY

X 12/01/15 30

Y 12/01/15 30

Re: Need help with Max date and sum set expression

swuehl — Wed, 02 Dec 2015 22:11:42 GMT

Just create a straight table chart with dimension Name,

then create two expressions

=Date(Max([Sale Date]))

=Sum(QTY)

Re: Need help with Max date and sum set expression

hemhund2016 — Wed, 02 Dec 2015 22:13:46 GMT

Hi,

create a straight table with below .

Dimension: Name

Expression1: max([Sale Date])

Expression2: sum(QTY)

Thanks,

Hemanth.

Re: Need help with Max date and sum set expression

Thu, 03 Dec 2015 14:03:07 GMT

Hi Kumar,

I already try that. But when you select both X and Y, it doesnt work. Because the expression will look for the max sale date across X and Y data. And return one max date.

Tks,

Kenny

Re: Need help with Max date and sum set expression

hemhund2016 — Thu, 03 Dec 2015 16:38:01 GMT

Hi Kenny,

can you attach the qvw to check the issue?

Re: Need help with Max date and sum set expression

sunny_talwar — Thu, 03 Dec 2015 16:42:28 GMT

Not sure what you mean, but seems to be working here:

Re: Need help with Max date and sum set expression

Thu, 03 Dec 2015 16:48:03 GMT

Hi All,

Yes. It works. I am fairly new to Qlikview tool.

Thank you all for the helps.