I have a measure for KPI with below set expression =(Sum({<[OrderDate]={">=$(=YearStart(max([OrderDate])))<=$(=Max([OrderDate]))"}>} Sales))/1000, for this value is like 4.3k , but i want to show $ 4.3k as output , so how to add $ symbol Infront of it or is there any other way to display KPI YTD value like $ 4,3k instead of
$ 4299865.87 .Here i have selected Number formatting as Money ($ ###0.00;-$ ###0.00)
Hi, to format a KPI in Qlik Sense to show a value with a dollar sign and in thousands (e.g., $ 4.3k), you can use a combination of the formatting functions and set expressions directly in the measure expression. Here's how you can achieve that:
Hi, to format a KPI in Qlik Sense to show a value with a dollar sign and in thousands (e.g., $ 4.3k), you can use a combination of the formatting functions and set expressions directly in the measure expression. Here's how you can achieve that:
