# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Valued Contributor II

My QV Doc

MVP

## 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

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