Show KPI's

[Anonymous]

Hi,

I think this may be a very simple question, but I am new in Qlick and I don't find the answer.

I have seen in some qlickview dashboard a KPI in a unique number (not a graph, not a table, not a object) only the number:

For example: total sales month: 250.000 euros,     average sale: 56,65 euros.

I mean only the number, with big letters, Which object do I have tu use???

Thanks in advance

[Anonymous · Accepted solution]

Most likely text box with expression.

[Anonymous]

I am trying with a text box with expresion, but it put the expresion as a literal

sum(sales)

insteda of the total(sales) value ....250.000 euros

Ant help?

[Anonymous]

It should be like this, starting with the "=":

=money(sum(sales)) & ' euros'

If you need to specify money format different from the one you have as default, you can use:

=money(sum(sales), 'whatever format you want here') & ' euros'

[Anonymous]

Thank you very much

[Anonymous]

Another quick question:

=money(sum(sales)) & ' euros'    it works...

but

'total sales: '  & =money(sum(sales))

it doesn't work, because it doesn't resolve sum(sales) it puts the literal

bay help?

[Anonymous]

Sure.

The text box expression must always start with "=":

='total sales: '  &  money(sum(sales))

[satishkurra]

Text Object is the best way to show KPI's in qlikview with no images and representations.

Also while using expression in General tab of text object, use = and then followed with your expression.

Thanks

Satish