Discussion Board for collaboration on QlikView Scripting.
I have below expression , i like to add the expression with RangeSum(Above :-
I have try the below expression , but it does not work :-
$(ColumnDim51)/$(Columndim89)/1000, 0, RowNo(TOTAL)))
May i know why ?
In my next posting i will post my QV Doc
My QV Doc
$(ColumnDim51)/$(Columndim89)/1000), 0, RowNo(TOTAL))
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.
Enclosed my QV Doc