Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 ...
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 <', ' - ')
Thanks ANIL babu,
Second expression works for me. Thank you so much
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
Try this simple way and let us know if this works for you
Class(Age, 5)
OR
Replace(Class(Age, 5),'<=X <','-')
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.
You may read this