topic Re: dollar value in QlikView

dollar value

manoranjan_d — Thu, 16 Jun 2016 11:29:13 GMT

Hi,

I m huge amount and low amount , i want to display the amount in dollars in stack back.

example: if we have 2120453 then it should show $2.12 in the stack bar chart inside plot segments, how to show this.

And also above is an example amount ,another example amount which will more amount 2120453 or it can be 212045606 and another example it low amount.

how to show this?

varshavig12 — Thu, 16 Jun 2016 11:41:04 GMT

Create an inline convert

Currency_Format:

LOAD * INLINE [

Unit, Convert

Actual,1

Thousand, 1000

Million, 1000000

Billion, 100000000

];

example:

If your expression is sum of stock:

sum(stock)/Convert

and then you can select any Unit.

This will reflect in your bar chart.