Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

doubt with NUM

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'))

grafica3.jpg

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?

grafica2.jpg

3 Replies
Not applicable

Re: doubt with NUM

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'


AlbertoV
Contributor III

Re: doubt with NUM

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

Alberto

Not applicable

Re: doubt with NUM

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'

Community Browser