topic Re: Calculations using Text box in QlikView

Calculations using Text box

Wed, 08 Jan 2014 11:42:55 GMT

Dear All,

I was trying to show the percentage difference via text box. But it appears like 24.657345. How can I Make it a whole number in Text box or should I use some other object for the same

and How should I add % sign after my whole number?

Thanks in advance !!!

Regards

Anjana

Re: Calculations using Text box

Wed, 08 Jan 2014 11:54:29 GMT

try this

=num(yourexpression,'##.##%')

for eg:

=num(Avg(sales),'##.##%')

Re: Calculations using Text box

danieloberbilli — Wed, 08 Jan 2014 11:55:48 GMT

try

=num(24.657345 / 100, '0%')

Re: Calculations using Text box

Anonymous — Wed, 08 Jan 2014 11:57:02 GMT

Hi,

You should put it like this in the text-field :

=Num([SKU Length]/[SKU Height],0) & ' %'

where [SKU Length] / [SKU Height] is your calculated field.

When you put it like this :

=Num([SKU Length]/[SKU Height],0.00) & ' %'

you get 2 digits after the decimal sign.

Paul

Re: Calculations using Text box

Wed, 08 Jan 2014 11:57:03 GMT

=num(Expression,'#,##0.00%') this will give you 2 decimal..

The Expression output is already a percentage value the you have to concatenate %

like this

=num(Expression,'#,##0.00') &'%' this will give you 2 decimal..

Re: Calculations using Text box

manideep78 — Wed, 08 Jan 2014 12:03:47 GMT

Hi Anjana

Try this in you Text Object

=Round(<Your Difference Expression>) &'%'

Eg. =Round(12.3456-7.2568) &'%' = 5%

Hope this Helps

Regards,

Manideep

Re: Calculations using Text box

Anonymous — Wed, 08 Jan 2014 13:57:17 GMT

Hi,

Just forgot to mention, this way of listing things is possible in all text-fields. I use it a lot in the titles of a table or chart. The great advantage of this is that the user can leave the table minimized and still see the endresult and don't have to open the whole table (sometimes slow) to see the same percentage (or total).

An other small tip, with chr(10) you can force a line feed. So with

='Length : ' & [SKU Length] & chr(10) & 'Height : ' & [SKU Height]

you get 2 lines like this :

Length : 4.235

Height : 1.125

Thanks for the credit

Paul