Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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.

Highlighted
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

Community Browser