topic Re: How to Add Rangsum function to my SET expression ? in QlikView

How to Add Rangsum function to my SET expression ?

paulyeo11 — Fri, 26 Feb 2016 06:13:34 GMT

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

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

paulyeo11 — Fri, 26 Feb 2016 06:16:02 GMT

My QV Doc

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

tresB — Fri, 26 Feb 2016 06:27:39 GMT

Try:

money(RangeSum(Above(TOTAL

Sum(

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

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

, $(vMoneyFormatK)))

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

jagan — Fri, 26 Feb 2016 06:29:23 GMT

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.

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

paulyeo11 — Fri, 26 Feb 2016 13:54:15 GMT

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

. !

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

paulyeo11 — Fri, 26 Feb 2016 13:55:54 GMT

Enclosed my QV Doc