topic Re: Interaction Match Issue in QlikView

Interaction Match Issue

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Interaction Match Issue

sunny_talwar — Mon, 26 Sep 2016 15:49:06 GMT

Interaction match? Do you mean Interval Match or something else? Would you be able to share a sample to demonstrate what you are trying to do?

Re: Interaction Match Issue

krishnacbe — Mon, 26 Sep 2016 15:49:08 GMT

Hi,

Please share some sample data and output you are expecting. that will help us to provide the soultion

Re: Interaction Match Issue

Anonymous — Mon, 26 Sep 2016 15:50:03 GMT

Hi,

Please, add your qvw file or other, so we can see what you want to do.

Re: Interaction Match Issue

Anil_Babu_Samineni — Tue, 27 Sep 2016 07:55:42 GMT

Deepa Agarwal,

I've read few months back about interaction match. Does it related to Bucket like 0-10, 0-20, 0-30 .....

Can you please elaborate more?

Re: Interaction Match Issue

Tue, 27 Sep 2016 08:09:35 GMT

Sunny, Might be i am not the good exaplainer. Might be this best way to approach i've tried this

Aggr(If($(eLoadFactor) <20,'0-20', If($(eLoadFactor) >20 and <40 ,'21-39', If($(eLoadFactor) >=40 and <60,'40-59', >= 59,'59-100', [Carrier Name])

Anil - you are correct

Krishnapriya & Filip, This is not possible because i am working for secured project. If i released sample data might be stakeholder will frustation on me. I know how to scramble data. In fact, i don't want to take risk. For ref, please follow the above expression

Re: Interaction Match Issue

sunny_talwar — Tue, 27 Sep 2016 17:28:01 GMT

So you above provided expression worked for you?

Re: Interaction Match Issue

Anonymous — Tue, 27 Sep 2016 20:18:18 GMT

Hi Deepa,

You Can you Class function to create Buckets.

class(aggr(eLoadFactor,[Carrier Name]),10,'X')

Re: Interaction Match Issue

rupamjyotidas — Tue, 27 Sep 2016 20:29:58 GMT

Instead of trying in expression, Create your 'interaction match' or Bucket in the script, in this way you don't complicate your expression and its easy to handle.

Re: Interaction Match Issue

Anil_Babu_Samineni — Wed, 28 Sep 2016 05:45:18 GMT

Deepa Agarwal,

I've taken Nitin Expression. Try this too

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

Re: Interaction Match Issue

Wed, 28 Sep 2016 05:52:39 GMT

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 ...

Re: Interaction Match Issue

Anil_Babu_Samineni — Fri, 30 Sep 2016 08:15:08 GMT

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 <', ' - ')

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

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

Re: Interaction Match Issue

Sat, 01 Oct 2016 05:27:11 GMT

Thanks ANIL babu,

Second expression works for me. Thank you so much

Re: Interaction Match Issue

Fri, 18 Nov 2016 01:12:11 GMT

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

Re: Interaction Match Issue

Anil_Babu_Samineni — Fri, 18 Nov 2016 04:59:12 GMT

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

Class(Age, 5)

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

Re: Interaction Match Issue

Fri, 18 Nov 2016 05:15:26 GMT

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.

Re: Interaction Match Issue

Anil_Babu_Samineni — Fri, 18 Nov 2016 05:30:31 GMT

You may read this