Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello community,
i have this doubt in my app
i created a bar chart in which i used below expression as measure:
this expression checks the value and if its greater than 1cr is appends cr after the value else it appends lacs.
after using this i'm getting following output:
please help..
Hi,
maybe one solution could be:
using this expression:
If(Sum(Persons)>10000000,
Dual(Money(Sum(Persons)/10000000, '###.##Cr',',','.'),Sum(Persons)),
Dual(Money(Sum(Persons)/100000, '###.##Lacs',',','.'),Sum(Persons))
)
hope this helps
regards
Marco
or sorted by measure expression value:
hope this helps
regards
Marco
hello sir, marcowedel
I came up with one problem with this expression,
If(Sum([Sales Amount])>10000000,
Dual(Money(Sum([Sales Amount])/10000000, '###.##Cr','.'),Sum([Sales Amount])),
If(Sum([Sales Amount])<100000000 and Sum([Sales Amount])>100000,
Dual(Money(Sum([Sales Amount])/100000, '###.##Lacs','.'),Sum([Sales Amount])),
If(Sum([Sales Amount])<100000 and Sum([Sales Amount])>0,
Dual(Money(Sum([Sales Amount])/1000, '###.##K','.'),Sum([Sales Amount]))
,If(Sum([Sales Amount])=0,0.00)
)
)
)
in this, it shows value in lacs crore and thousands but what if the value is negative ?? it fails to display those values in the format defined by expression, please help me with this sir.
Example:
Hi,
you could check e.g. for fabs(Sum(Persons))>100000
see also:
Fabs - script and chart function ‒ QlikView
regards
Marco
Yes this works but what if I want to show value in negative if it is negative,
like if my table has values like
example: some positive and some negative values
FY Year Name | cr& lac Final correct |
2010-11 | 0.00 |
2011-12 | -12.71Cr (negative) |
2012-13 | 51.03Cr |
2013-14 | 62.95Cr |
2014-15 | 64.15Cr |
2015-16 | 114.84Cr |
2016-17 | -76.88Cr (negative) |
2017-18 | 50.69Cr |
- | 24.12K |
regards
Pranav