Prefix in KPI

[dineshraj]

Hi Experts,

I need to add '$' symbol before my measure. I get the output by using this Expression.

pick(ceil(log10(sum(Sales))/3),

          num(sum(Sales),'#,##0.0'),

          num(sum(Sales)/1000,'#,##0.0 K'),

          num(sum(Sales)/1000000,'#,##0.0 M')

     ) & ''

(This is answered by gwassenaar)

But i can't get the conditional Colors

Could anyone help

Thanks in Advance

[#2]

Hi,

Go to Properties--> Dimensions and In the Dimensions tab and In the label type anything you like to display. eg:'$' & 'brand'

thanks

[anushree1]

Try using the Num Format like: num(sum(Sales),'$#,##0.00')

[dineshraj]

Hi Anushree,

I get the output but i am not able to give conditional Colors

[dineshraj]

Hi Prem,

This is not what i am expecting

[anushree1]

Hi Dinesh,

Do you mean conditional Background colors, if yes you could do that in Dimensions/Expressions Tab based on your requirement by Movin to the Background colors section as in the attachment.

It would be better if you could share a sample application if this is not what you are looking for.

[dineshraj]

Hi Anu,

My requirement is for qlik sense.In qlik sense KPI can't be colored if string is in your expression. so i am asking Is there any other method for conditional colors???