topic maxstring by dimension in QlikView

maxstring by dimension

Thu, 31 Oct 2013 17:18:15 GMT

Hi,

I have the following data.

what should the expression be if i want to create a bar chart and display by DELIV MONTH (axis x) for the max sales date of qty?

DELIV MONTH, SALES DATE, QTY
JAN , 10 JAN , 10

JAN , 11 JAN , 12

JAN , 12 JAN , 23

FEB , 22 FEB , 22

FEB , 23 FEB , 30

thanks.

Clever_Anjos — Thu, 31 Oct 2013 17:23:22 GMT

Use firstsortedvalue(QTY,-[SALESDATE])

Thu, 31 Oct 2013 17:27:44 GMT

i was thinking.. COUNT(aggr( MAX(SALESDATE), qty))

Clever_Anjos — Thu, 31 Oct 2013 17:46:35 GMT

Maybe I´m losing something, my English is not very good.

You want

a) The date with maximum sales?

b) Sales from the maximum date?

Thu, 31 Oct 2013 18:37:59 GMT

Hi;

I hope this can help you!!!

regards!!