Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
paulyeo11
Valued Contributor II

How to Add Rangsum function to my SET expression ?

Hi All

I have below expression , i like to add the expression with RangeSum(Above :-

money(

Sum(

{<Year={'>$(=year(today())-2)'}>}

$(ColumnDim51)/$(Columndim89)/1000)

, $(vMoneyFormatK))

I have try the below expression , but it does not work :-

money(RangeSum(Above(TOTAL

Sum(

{<Year={'>$(=year(today())-2)'}>}

$(ColumnDim51)/$(Columndim89)/1000, 0, RowNo(TOTAL)))

, $(vMoneyFormatK))

May i know why ?

In my next posting i will post my QV Doc

Paul

5 Replies
paulyeo11
Valued Contributor II

Re: How to Add Rangsum function to my SET expression ?

My QV Doc

MVP
MVP

Re: How to Add Rangsum function to my SET expression ?

Try:

money(RangeSum(Above(TOTAL

Sum(

{<Year={'>$(=year(today())-2)'}>}

$(ColumnDim51)/$(Columndim89)/1000), 0, RowNo(TOTAL))

, $(vMoneyFormatK)))

MVP
MVP

Re: How to Add Rangsum function to my SET expression ?

Hi,

Try this

money(

RangeSum(Above(Sum(

{<Year={'>$(=year(today())-2)'}>}

$(ColumnDim51)/$(Columndim89)/1000)),

Sum(

{<Year={'>$(=year(today())-2)'}>}

$(ColumnDim51)/$(Columndim89)/1000)

, $(vMoneyFormatK)))

Regards,

jagan.

paulyeo11
Valued Contributor II

Re: How to Add Rangsum function to my SET expression ?

Hi Jagan and Tres

As i learn from Sunny , When he add RangSum to my expression it can help my chart can display Currency sign.

Thank you for your sharing. I try Both your expression into my QC Doc the chart display wrongly.

AS my hope is :-

When i click on S$

Chart 1 will display

S$ with sale amount.

Line 1 = 2016 Red color will display jan and feb 2016 sales

Line 2 = 2015 Blue Color will display Jan till Dec sales.

When i Click on Currency = Org

The value above the line will convert the Amount Org currency amount. for example RM$

My issue now is currency sign is not able to display and decimal point not correct.

Paul

. !

paulyeo11
Valued Contributor II

Re: How to Add Rangsum function to my SET expression ?

Enclosed my QV Doc