topic Re: Above function with 2 dimensions in QlikView

Above function with 2 dimensions

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Have a table with having 3 fields..like below

Output:

Here am attaching the Qvw for the same which i tried.

Basically every month having 4 type of ratings and their activity.

Want to show for jan month activity should show in feb activity and feb activity should show in Mar activity....

I have been used some functions with combination of above but am not getting correct result.

Thanks in advance...

swuehl — Mon, 18 Sep 2017 15:47:55 GMT

You've almost done it.

Just change the order of aggr dimensions

only( aggr (above(sum( {$<month=,rating=>}active),1,4),rating,month))

effinty2112 — Mon, 18 Sep 2017 15:55:03 GMT

Hello,

Maybe:

month	rating	sum(active)	above(TOTAL sum(active),4)
		318
jan	A	21
jan	B	22
jan	C	23
jan	D	24
feb	A	25	21
feb	B	26	22
feb	C	27	23
feb	D	28	24
mar	A	29	25
mar	B	30	26
mar	C	31	27
mar	D	32	28

Just ensure that your table is sorted by month then rating.

Regards

Andrew