Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

dineshraj
Contributor

Prefix in KPI

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
6 Replies
Not applicable

Re: Prefix in KPI

Hi,

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

thanks

anushree1
Contributor III

Re: Prefix in KPI

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

dineshraj
Contributor

Re: Prefix in KPI

Hi Anushree,

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

dineshraj
Contributor

Re: Prefix in KPI

Hi Prem,

This is not what i am expecting

anushree1
Contributor III

Re: Prefix in KPI

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
Contributor

Re: Prefix in KPI

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???

Thread.JPG

Community Browser