topic Expression in QlikView

Expression

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

Hi All,

I have the below return code ,

if(Aggr(

Count(DISTINCT

{$<

Date={">=$(StartDate)<=$(EndDate)"},

Model = ,

Region_Hierarchy_Name = {'GLOBE'},

Dept= P(Dept_F)

>} Revenue

), Model

There is a field by name "Model" and content within taht field is like

1-cosmatic , 2-cosmateics , Full-cosmatic , clean -cosmatics, X-cosmatics, 4 -cosmatics ..... and so on ,

Now i want to display count of first 7 models names and above 7 models names should appear like others.

How do i achieve this in the existing code.

Becuase the above code is giving me all the models.

Regards

John

sunny_talwar — Thu, 08 Sep 2016 09:12:37 GMT

What is the dimension here? and have you looked into dimension limits if you have Model_Series as your dimension?

susovan — Thu, 08 Sep 2016 09:20:43 GMT

You can try this below attached process to restricted you calculated dimension.

smilingjohn — Thu, 08 Sep 2016 09:23:36 GMT

Thanks sunny ,

But there is no dimensions here , there is a long script of the aboive code , and this script will give the output as legends on extention object .

So just need to confirm if there is any way of getting the requirement through the code