topic Re: Numbering in QlikView

Numbering

Wed, 25 Nov 2020 16:16:04 GMT

Displaying to show numbers in Millions ---'M' and billions-----'B' and in thosands like -'k',plz explain the expression

sudeepkm — Thu, 21 Sep 2017 17:09:56 GMT

Chart properties > Number

sudeepkm — Thu, 21 Sep 2017 17:32:18 GMT

another approach would be to use DUAL function.

In the Script:

set hideprefix = '_';

LOAD dual(fig,num) as _val;

Load * inline [

num,fig

1000,K

1000000,M

1000000000,B

];

Then in the UI: whenever user selects either K or M or B then the expression will change amount accordingly.

Mon, 25 Sep 2017 07:19:37 GMT

thank you sudeep for your answer thank you so much,i will ask one more doubt plz explain