Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a chart with filter selections. attached is the sample app n data source.
require your suggestions
Hi,
Change your script like below
Country:
LOAD
*,
if( Index([IPG_KRANGE],'-')<1,1,
num(PurgeChar( mid([IPG_KRANGE], Index([IPG_KRANGE],'-') +1),'K'))
) AS IPG_VALUE;
LOAD Name,
Country,
IPGK,
//IPGKRANGE,
if(IPGKRANGE ='-',Dual('-',1),
if(IPGKRANGE = 'Less than 1K',Dual('Less than 1K',2),
if(IPGKRANGE = '1.000-4.999K','1000-4999K',
if(IPGKRANGE='5.000-9.999K','5000-9999K',
if(IPGKRANGE='10.000-19.999K','10000-19999K',
if(IPGKRANGE='20.000K or more','20000K or more',IPGKRANGE)))))) as IPG_KRANGE,
Modes,
Latitude,
Longitude,
PSGK,
PSGKRANGE,
psgkrange,
Zip_Code
FROM
(biff, embedded labels, table is Sheet1$);
Now use
=Max(IPG_VALUE)
as expression for IPG_KRANGE.
REgards,
Jagan.