topic Re: Dimmension Problem in QlikView

Dimmension Problem

pgalvezt — Fri, 19 Oct 2012 12:15:16 GMT

Hello,

I'm doing an stratification by debt days within with percentages. 'Comercio' has a lot of client one of them needs to put all debt inside 'To Date' (Al Día).

I need this

Al día And 0% For Inp Customer.

The other Customer has to have all percentages.

This is my 1st Dimmension if(Comercio='Inp' or isnull(Comercio), 'Al Día', Descripcion)

This is my 2nd Dimmension If(Comercio= 'Inp',Num(Porc_Provision,'0%'))

I attached a picture that show the current result.

Thanks!

Re: Dimmension Problem

pgalvezt — Fri, 19 Oct 2012 18:19:30 GMT

Any Help?

Thanks!

Re: Dimmension Problem

MayilVahanan — Fri, 19 Oct 2012 18:25:12 GMT

From This , If(Comercio= 'Inp',Num(Porc_Provision,'0%'))

if comerico value is not inp, what to display is not mention? so only it display the '-' value, so please give the else part..

Hope it helps

Re: Dimmension Problem

pgalvezt — Fri, 19 Oct 2012 19:52:39 GMT

Nice. You're right I just to put the other part. Just one question my percentages appears like 0.01 0.1 0.2 and so on What function is better to left it like 1% 2% and so on.

Thanks!

Re: Dimmension Problem

MayilVahanan — Fri, 19 Oct 2012 20:00:45 GMT

Try like this

Num( Sum(Sales),#.#0% )

In number tab, use fixed to 1 and tick the show in percent.

Both helps