Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi every one...
is there Any one help me how to Show money value in qlikview..
=numsum({$<Year={$(=only(Year))}>}PriceIncludingDiscount)),'##.##')... in this example how this # will show tha value..i
get confuse('##.##') about this. how its works.. as well if i want to show Value in Rupees so how we can do this..
like if it is 25000 than show 25k.. if its 250000 than show 2.5L and more value.. but in indian Rupees Only..i dont want show value in
Dollar or either Pound .. kinldy help me to understand this
Hi,
Try from here:
Thanks,
AS
NumSum (which is now obsolete and has been replaced by RangeSum()) treats its parameters as a list of numeric value and sums those values. It does not work on a field and does not take a set expression as a parameter. It does not accept a format parameter. I think what you mean to do is this:
Num(Sum({$<Year={$(=only(Year))}>} PriceIncludingDiscount),'0.##')
(if it is a chart expression, you can format it in the Numbers tab of the chart properties and do not need the Num().)
As far as displaying the values as k or in lakh, you will have to the arithmetic yourself and format the value accordingly. Something like:
If(Sum({$<Year={$(=only(Year))}>} PriceIncludingDiscount) > 100000,
Num(Sum({$<Year={$(=only(Year))}>} PriceIncludingDiscount)/100000, '0.00') & 'L',
If(Sum({$<Year={$(=only(Year))}>} PriceIncludingDiscount) > 1000,
Num(Sum({$<Year={$(=only(Year))}>} PriceIncludingDiscount)/1000, '0.00') & 'k',
Num(Sum({$<Year={$(=only(Year))}>} PriceIncludingDiscount), '0.00')
))
This could perform poorly because the sum is being performed 4 times and they will not export nicely to Excel...
thanks Amit. this one i know .. I m not Understanding this Format Patter..$#,##0.00;($#,##0.00).. can u help me to understand this.. for all pattern for number , integer and fixed to ... how to show Symbol fo Rupees
Thanks Jonathan.. but In my Application .. i Have Multiple expression .. so for every expression i need to define
if else.. is there any simple way to do this..
Hi Brijesh,
There is two ways to display currency in your req....
1. In Expression you can give $#,##0.00;
2. Going Object ( you req ) -> Properties -> Number Tab -> Choose Money Radio button -> Format pattern give your format( Your req)
Ramya.