Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have question in recent scenario i have straight table and values below like this and i wanted show values and sorting become specific order.
output needs to be below like this.key points field are sorted to specific order and reduced to only two digits. above mentioned is the example and below is the output.how do i do? !
in "number" tab select "fixed to" and set 2 digits.then in sort select REGION (press on promote to set it as first item)
Hi,
You can format number by go to chart property->Number->Fixed to->2
and if you want with specific order
go to sort->select field->in sort write expression->match(Region,'Americas','Asia*','Europe','Africa')
Regards
You can limit number as 2 decimal points in Properties->Number->Fixed with 2 decimal.
For sorting, what is the logic for the specific sort order?
Hi,
If you share the sample file or data then it would be easier to give solution, without this it is difficult to answer.
Go through below link for some useful tips to get the answers quickly
Qlik Community Tip: Posting Successful Discussion Threads
Regards,
Jagan.
max dreamer wrote:
go to sort->select field->in sort write expression->match(Region,'Americas','Asia*','Europe','Africa')
That should be
=wildmatch(Region,'Americas','Asia*','Europe','Africa')
Hi veerendra999,
Can you attach the sample file?
Here it is
Thanks Guys for sharing your valuable experience
kindly challenge below gauge chart because i have 3 years of date each your should be show indicator like below per each year how to solve share me screen shots
my dimension:
year: 10-11
11-12
12-13
expression Sum(Revenue)
share me screens..
I suggest that you create a new post because this is a new question only loosely related to the original question.