Rank in script

[bharatkishore]

HI All,

I have  the following columns in script:

     Equipment,

     [Part Group],

     Key_EMS,

     Calendar,

     Age_Final

now in Age_Final i have the following output: and image for reference:

10

5

10

3

Now i need to get only min ages i.e. 3 and 5. I need to this in script. Do i need to use Rank(Guess it cannot be worked in script) or autonumber to get only min 2 ages.

Attaching qvw and excel for reference.

Please let me know how to do this.

Thanks,

Bharat

[timpoismans]

You're making groups based on the values of your dimensions.

Why does this have to happen in the script?

[bharatkishore]

Because i.e one the requirement and based on the the above logic will be deriving other steps in the script...

[timpoismans]

I don't think it's possible to load two rows where [Age_Final] is min. per unique value of your Equipment field

If you'd tell us what your goal is, perhaps we could help you further.

[bharatkishore]

I need to get the min age values  which are 2 min age values. For every record i mean for every equipment and Part Group and Calendar month.

In sql it has been developed with help of rank function there it has been considered as min of 2 ranks,

Hope you can understand the scenario

The same can we do in qlikview.

Please let me know if you need anything more.