topic Re: How to show products with constant improving perceptions , constant degrading perceptions and products which maintained status quo ? in QlikView

How to show products with constant improving perceptions , constant degrading perceptions and products which maintained status quo ?

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

Hi All ,

How to show products with constant improving perceptions , constant degrading perceptions and products which maintained status quo in separate objects ?

products with constant improving perceptions - In one straight table

products with constant degrading perceptions - Another straight table

products which same perceptions throughout - In a separate straight table

Using the attached data .

Thanks & Regards

Shekar.

Re: How to show products with constant improving perceptions , constant degrading perceptions and products which maintained status quo ?

Miguel_Angel_Baeyens — Fri, 28 Jul 2017 10:10:27 GMT

What happens when one period has two values, how to know which one is the latest one?

At a first glance, you can use the difference between Min() and Max() values for Perception_Coefficient with an If(), and with that get the values you want. Also FirstSortedValue() could help.

Without further elaboration and a closer to real life sample, this is all we can do

Re: How to show products with constant improving perceptions , constant degrading perceptions and products which maintained status quo ?

effinty2112 — Fri, 28 Jul 2017 10:22:28 GMT

Hi Shektar,

try these:

Expression:

=if(Max(Aggr(avg(Perception_Coefficient)-Above(avg(Perception_Coefficient)),(Product,text,ascending),(Year,numeric, ascending)))<0,'Y')

Product	products with constant declining perceptions
BAFFLES	Y
CERAMICS
EMP CHIP
EPSILON
FIDGETS
KNEE GUARD
NUTRI DRINK	Y
OXY RICH
ROTOR WIND
SNOW GOGGLES TYPE 2
WIRELESS SET

Expression:

=if(Min(Aggr(avg(Perception_Coefficient)-Above(avg(Perception_Coefficient)),(Product,text,ascending),(Year,numeric,ascending)))>0,'Y')

Product	products with constant improving perceptions
BAFFLES
CERAMICS
EMP CHIP
EPSILON
FIDGETS
KNEE GUARD
NUTRI DRINK
OXY RICH
ROTOR WIND
SNOW GOGGLES TYPE 2	Y
WIRELESS SET

Expression:

=if(Max(fabs(Aggr(avg(Perception_Coefficient)-Above(avg(Perception_Coefficient)),(Product,text,ascending),(Year,numeric,ascending))))=0,'Y')

Product	products with constant perception
BAFFLES
CERAMICS	Y
EMP CHIP
EPSILON	Y
FIDGETS
KNEE GUARD
NUTRI DRINK
OXY RICH	Y
ROTOR WIND
SNOW GOGGLES TYPE 2
WIRELESS SET

cheers

Andrew

Re: How to show products with constant improving perceptions , constant degrading perceptions and products which maintained status quo ?

effinty2112 — Fri, 28 Jul 2017 10:33:16 GMT

Hi Shektar,

I should have explained that in considering perceptions I have averaged this out over Regions so I'm considering what you might term global perceptions.

Regards

Andrew

Re: How to show products with constant improving perceptions , constant degrading perceptions and products which maintained status quo ?

shekhar_analyti — Sat, 29 Jul 2017 13:37:15 GMT

Hi Andrew ,

Thanks for reply !!

But expressions are not working .

Re: How to show products with constant improving perceptions , constant degrading perceptions and products which maintained status quo ?

Anonymous — Sat, 29 Jul 2017 14:10:43 GMT

I beleive you need to add the else section.Otherwise, Table will not display all records.

Example: Based on your first expresions:

=if(Max(Aggr(avg(Perception_Coefficient)-Above(avg(Perception_Coefficient)),(Product,text,ascending),(Year,numeric, ascending)))<0,'Y','')

I hope this helps

Re: How to show products with constant improving perceptions , constant degrading perceptions and products which maintained status quo ?

effinty2112 — Sat, 29 Jul 2017 15:23:02 GMT

Hi Imad,the expressions shown were copied from functioning straight tables. The tables shown were the results. Believe me the expressions work. Thanks

Re: How to show products with constant improving perceptions , constant degrading perceptions and products which maintained status quo ?

shekhar_analyti — Sat, 29 Jul 2017 18:02:06 GMT

it will be helpful , if you attach qvw with same ..

thank you

shekar

Re: How to show products with constant improving perceptions , constant degrading perceptions and products which maintained status quo ?

shekhar_analyti — Mon, 31 Jul 2017 08:15:40 GMT

imadzidan‌

Re: How to show products with constant improving perceptions , constant degrading perceptions and products which maintained status quo ?

shekhar_analyti — Mon, 31 Jul 2017 08:16:44 GMT

imadzidan attach qvw

Re: How to show products with constant improving perceptions , constant degrading perceptions and products which maintained status quo ?

shekhar_analyti — Wed, 02 Aug 2017 08:49:35 GMT

antoniotiman‌

Re: How to show products with constant improving perceptions , constant degrading perceptions and products which maintained status quo ?

shekhar_analyti — Wed, 02 Aug 2017 12:42:05 GMT

stalwar1‌ ... please help

Re: How to show products with constant improving perceptions , constant degrading perceptions and products which maintained status quo ?

sunny_talwar — Wed, 02 Aug 2017 16:10:04 GMT

If that has not been resolved, do you mind pointing out the expected output based on your attached sample?