Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

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

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

3 Replies
paulyeo11
Valued Contributor II

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

My QV Doc

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

write this expresion

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

paulyeo11
Valued Contributor II

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

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

Community Browser