topic Re: Need Help in Building KPIs in QlikView

Need Help in Building KPIs

QlikNoviceNo1 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Need Help in Building KPIs

Victor_Alumanah — Mon, 21 Oct 2019 15:36:57 GMT

Here you go

Re: Need Help in Building KPIs

mohamed_ahid — Tue, 22 Oct 2019 07:55:17 GMT

Hello

can you share your sample QVW ?

Regards

Re: Need Help in Building KPIs

QlikNoviceNo1 — Tue, 22 Oct 2019 19:33:24 GMT

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

Re: Need Help in Building KPIs

Brett_Bleess — Wed, 30 Oct 2019 16:39:31 GMT

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