topic Re: Show KPI's in QlikView

Show KPI's

Anonymous — Sun, 19 Apr 2015 22:08:19 GMT

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 — Sun, 19 Apr 2015 22:30:47 GMT

Most likely text box with expression.

Anonymous — Sun, 19 Apr 2015 22:40:30 GMT

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 — Sun, 19 Apr 2015 22:58:22 GMT

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 — Sun, 19 Apr 2015 23:01:50 GMT

Thank you very much

Anonymous — Mon, 20 Apr 2015 09:25:07 GMT

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 — Mon, 20 Apr 2015 11:27:00 GMT

Sure.

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

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

satishkurra — Mon, 20 Apr 2015 11:30:25 GMT

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