topic Re: Using set analysis in QlikView

Using set analysis

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

Hello,

i created this pivot table in which i applied Pareto method.

As you can see here there are values of acuracy [column 3] greater or equal than 80%. What i want to do is to keep only accuracy values less than 80%.

I heard that i can use set analysis in this case but i do not know how to use. Please, any help.

Thank you very much.

Best regards,

Alâa Eddine.

Re: Using set analysis

sunny_talwar — Mon, 06 Aug 2018 12:51:29 GMT

May be check this out

Recipe for a Pareto Analysis – Revisited

Re: Using set analysis

rick_vansoest — Mon, 06 Aug 2018 12:54:33 GMT

you could create a calculated dimension? Something like:

IF( AGGR(

//Your measure

, [Aggr Brand]) <= 0.8 , [Aggr Brand] )

After creating the dimension you select "suppress zero values"

Re: Using set analysis

Anonymous — Mon, 06 Aug 2018 14:00:00 GMT

Hello,

thank you but do you have an idea about set analysis? because i do not know how to use the aggr function.

Thank you,

Alâa Eddine

Re: Using set analysis

rick_vansoest — Tue, 07 Aug 2018 11:50:05 GMT

I don't think there is an easier way of fixing this than with the aggr function in either the dimension or the set analysis. If you are going to use Qlikview frequently, I suggest you look in to this. It is a powerful function.

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/ChartFunctions/aggr.htm

If you don’t have the time to dive into the matter maybe this is a solution:

Change the pivot table to a straight table and set the dimension limits to only show values greater than 0.8