Interaction Match Issue

[#1]

Hello Gurus,

Can you please help me this, I've shucked here.

I created one variable like below

eLoadFactor = (Sum ([# Transported Passengers]) / Sum ([# Available Seats]))

Now, I want to create interaction match with the field of "Carrier Name". Please help me

Especially Sunny, Suehl and Gysbert or any thing else.

[#2]

No Sunny, This is not working. Would you provide me best way to write the Buckets in qlikview.

I've replied very fast. But this reply is under modification.

Nitin - Thanks for that, I've use your expression. This shouldn't give any values

Rupam - Can you povide me how to write in script

Anil - Very close to reuirement, But values gave 1-100, 101-200 ....

I am expecting 1-20, 21-40, 41-60 ...

[Anil_Babu_Samineni · Accepted solution]

Try This, Sunny does this metric is correct? I am not sure if that helps to Deepa Agarwal. Try Luck

=Aggr(Class($(eLoadFactor) * 100 ,10), [Carrier Name], '<= x <', ' - ')

OR

=Replace(Aggr(Class($(eLoadFactor) * 100 ,10), [Carrier Name]), '<= x <', ' - ')

OR

=Replace(Aggr(Class('$(eLoadFactor)' * 100 ,10), [Carrier Name]), '<= x <', ' - ')

[#4]

Thanks ANIL babu,

Second expression works for me. Thank you so much

[#5]

Sunny & Anil Babu

Can you help me on this

I have simple age, I want to calculate kind

0-5, 5-10, 10-15,...

Thanks in advance, if you would like to branch to New discussion that's fine for me

[Anil_Babu_Samineni]

Try this simple way and let us know if this works for you

Class(Age, 5)

OR

Replace(Class(Age, 5),'<=X <','-')

[#7]

Anil Babu,

First one I tried earlier. It gives like below

0 <= X < 5

5 <= X < 10

10 <= X < 15

....

But, Second one gives exact one. Can I know the reason to filter out.

[Anil_Babu_Samineni]

You may read this