topic 2015 display 903K wrong , How to make it display 110K ? in QlikView

2015 display 903K wrong , How to make it display 110K ?

paulyeo11 — Thu, 31 Mar 2016 15:00:48 GMT

Hi All

My scatter chart 1 expression display wrong value.

Sum({$<year={$(=Max(year)), $(=Max(year)-1)}, Month = {"<=$(=max({<year={$(= max(year))}>} Month))"} >} sales)/1000

2015 display 903K wrong , How to make it display 110K ?

My Table 1 display correct value.

Paul

paulyeo11 — Thu, 31 Mar 2016 15:02:43 GMT

My QV Doc

Kushal_Chawda — Thu, 31 Mar 2016 15:28:43 GMT

write this expresion

SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},rEVENUE={rEVENUE}>}Amount*1)/$(Columndim89)/1000

paulyeo11 — Thu, 31 Mar 2016 23:17:11 GMT

Hi Kush

Thank you for sharing.

This chart i expect it to show the figure same as table .

Meaning it should show the sales for 2016 YTD compare with 2015 YTD.

Paul

Sent from my iPhone