topic Re: Prefix in KPI in App Development

Prefix in KPI

dineshraj — Tue, 14 Mar 2017 07:30:10 GMT

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

Re: Prefix in KPI

Tue, 14 Mar 2017 07:42:56 GMT

Hi,

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

thanks

Re: Prefix in KPI

anushree1 — Tue, 14 Mar 2017 07:43:31 GMT

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

Re: Prefix in KPI

dineshraj — Tue, 14 Mar 2017 07:50:07 GMT

Hi Anushree,

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

Re: Prefix in KPI

dineshraj — Tue, 14 Mar 2017 07:51:02 GMT

Hi Prem,

This is not what i am expecting

Re: Prefix in KPI

anushree1 — Tue, 14 Mar 2017 07:58:27 GMT

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.

Re: Prefix in KPI

dineshraj — Tue, 14 Mar 2017 08:08:13 GMT

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