Need Help in Building KPIs

[QlikNoviceNo1]

Hi Folks am new to Qlik and am trying out some practise exercises and trying to build the below KPIs.

1. If a state has a total quantity greater than 5000, categorize it as "Great". If it has a total quantity greater than 1000, categorize it as "Good". Categorize all other states as "Needs Improvement". How many states fall into the "Good" category?

--- For this one I Was able to build a chart that catgorizes the items.

But for the last part, ie Number of states falling into Good category, I am thinking of displaying it in a text object, but not able to build an expression 😞

2. What is the percent of total sales for the Tables subcategory? How does this compare to Chairs?

-- In which form do we display this and how?

3. How many orders were returned in February of 2016? What were the sales and profits associated with these returned orders?

4. Show the cities we sell to in Texas by their total gross sales. What are my top two cities by gross sales? What are my bottom two?

5. Display some Year over Year KPIs.

Please help on how we can achieve this

[Victor_Alumanah]

Here you go

[mohamed_ahid]

Hello

can you share your sample QVW ?

Regards

[QlikNoviceNo1]

I don't have one yet. Just the data set is available.

[Brett_Bleess]

I would suggest having a look at the demo site applications for ideas and the other place to look would be the Design Blog area of Community:

https://demos.qlik.com/qlikview

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

The Design Blog link is the top level with a search dialog to help you find pertinent posts that may help you move things forward.  The demo site has quite a few apps as well that you should be able to download and look over for ideas.

Regards,
Brett