Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Most likely text box with expression.
Most likely text box with expression.
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?
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'
Thank you very much
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?
Sure.
The text box expression must always start with "=":
='total sales: ' & money(sum(sales))
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