topic Re: doubt with NUM in QlikView

doubt with NUM

Thu, 12 Dec 2013 23:47:42 GMT

I everyone;

I have a Bar graphic with TWO dimentions and what I need to do is give inside of expression the next condition and format:

if(CURRENCY_FILTRO='MXP',
NUM(SUM(if(CURRENCY_FILTRO='MXP',(ventapesos)/1000,if(moneda='USD',(ventaoriginal/1000),(ventapesos/rate_usd)/1000))),'€#,##0;-€#,##0'),
NUM(SUM(if(CURRENCY_FILTRO='MXP',(ventapesos)/1000,if(moneda='USD',(ventaoriginal/1000),(ventapesos/rate_usd)/1000))),'$#,##0;-$#,##0'))

how it work?

I have also one filter when I choose MXP I have the next format in the indicator: '€#,##0;-€#,##0'

when I choose USD I have the next format in the indicator: '$#,##0;-$#,##0'

BUT doesn't work why?

Because I have TWO dimentions,, Do exists someway to do or make this?

If I use only one dimention work it perfect but I need two dimentions!!!

Can you help me?

Re: doubt with NUM

Fri, 13 Dec 2013 00:08:21 GMT

TRy to create two graph (clone) without if condition on CURRENCY_FILTER,

and use Conditional Layout on

Graph MPX:

CURRENCY_FILTER='MPX'

Graph USD:

CURRENCY_FILTER='USD'

Re: doubt with NUM

albertovarela — Fri, 13 Dec 2013 00:09:25 GMT

Hello Omar, Check your then and else parameters; they are exactly the same...

Alberto

Re: doubt with NUM

Fri, 13 Dec 2013 13:47:31 GMT

Hi Alberto good moorning;

It's Correct they are the same buecause when Currency filter = 'MXP' then will show the same resut with format;'€#,##0;-€#,##0' ...If Currency filter = 'USD' then will show the same result but how with format: '$#,##0;-$#,##0'