topic Re: Index in QlikView

Index

tracycrown — Sat, 16 Nov 2024 21:40:59 GMT

Dear all

Kindly advise how to compute Average Sales grouped by Quarters?.

Correct answer is shown below :

t	Year	Quarter	Sales	INDEX
1	2014	1	4.8	5.7
2	2014	2	4.1	5.2
3	2014	3	6.0	7.1
4	2014	4	6.5	7.5
5	2015	1	5.8	5.7
6	2015	2	5.2	5.2
7	2015	3	6.8	7.1
8	2015	4	7.4	7.5
9	2016	1	6.0	5.7
10	2016	2	5.6	5.2
11	2016	3	7.5	7.1
12	2016	4	7.8	7.5
13	2017	1	6.3	5.7
14	2017	2	5.9	5.2
15	2017	3	8.0	7.1
16	2017	4	8.4	7.5

Thank you

Tracy

Re: Index

tracycrown — Thu, 27 Dec 2018 23:24:41 GMT

Dear all

Sorry, I forgot to enclose the files, please refer to attached file for details.

Thank you

Tracy

Re: Index

Gysbert_Wassenaar — Fri, 28 Dec 2018 06:26:11 GMT

Create a table or chart with Quarter as dimension and Avg(Sales) as expression.

Re: Index

tracycrown — Fri, 28 Dec 2018 06:39:41 GMT

Dear Gysbert

It works when I create another table but it dos not work if I present in the same table next to Sales Column, please advise.

Thank you

Tracy

Re: Index

Gysbert_Wassenaar — Fri, 28 Dec 2018 06:54:10 GMT

Try Avg( TOTAL <Quarter> Sales)

Re: Index

sathishbabu_s_g — Fri, 28 Dec 2018 20:05:16 GMT

Hi,

I use to do using below logic usually, using <Quarter> on the expression comes under set expression ? I would like to know other possibilities using this approach rather than aggr 🙂

aggr( avg(Sales), Quarter)

Re: Index

Gysbert_Wassenaar — Sat, 29 Dec 2018 08:43:06 GMT

Perhaps this blog post explains things: https://community.qlik.com/t5/Qlik-Design-Blog/When-should-the-Aggr-function-NOT-be-used/ba-p/1467855