Hello All, this community helped me lot by answering my questions or reading existing answers.
I am using KPI number format displaying with 1.22M which is correct with Auto Format, But I want display with one decimal format like 1.2M. if I change the format either Number or Custom , my KPI displaying complete KPI Values such as 1,222,200.97. How can is change format to display my KPI values as 1.2M without 2nd decimal and complete values.
I tried with Simply KPI extension and default Qliksense KPI object, but unable to display KPI values what I wanted.
Hello All and Gysbert, I try to with you your expression with KPI object, but it is not displaying what I wanted, such as 34.2M or 23.3K etc, depending on values.
the following code Answered by Rob.
I am able apply below code for showing dynamic values with correct format, but I just need to add one decimal to values, can you please check below code, and help me how to add decimal point from below code.
I create a variable in the script like this:
SET vScaleNumber=if($1>1000000, num($1/1000000,'#,##0.000M')