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
Just create a straight table chart with dimension Name,
then create two expressions
create a straight table with below .
Expression1: max([Sale Date])
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.
can you attach the qvw to check the issue?
Not sure what you mean, but seems to be working here:
Yes. It works. I am fairly new to Qlikview tool.
Thank you all for the helps.
Retrieving data ...