Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Need help with Max date and sum set expression

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

1 Solution

Accepted Solutions

Re: Need help with Max date and sum set expression

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

Capture.PNG

6 Replies
MVP
MVP

Re: Need help with Max date and sum set expression

Just create a straight table chart with dimension Name,

then create two expressions

=Date(Max([Sale Date]))

=Sum(QTY)

hemhund2016
Contributor

Re: Need help with Max date and sum set expression

Hi,

create a straight table with below .

Dimension: Name

Expression1:   max([Sale Date])

Expression2:   sum(QTY)

Thanks,

Hemanth.

Not applicable

Re: Need help with Max date and sum set expression

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

hemhund2016
Contributor

Re: Need help with Max date and sum set expression

Hi Kenny,

can you attach the qvw to check the issue?

Re: Need help with Max date and sum set expression

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

Capture.PNG

Not applicable

Re: Need help with Max date and sum set expression

Hi All,

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

Thank you all for the helps.

Community Browser