How to write set analysis

siva_boggarapu — Wed, 11 Jul 2012 09:45:10 GMT

Hi Everyone,

Can anyone help me how to write set analysis for this below three expression?

1)RangeMin($(vMarketFare1),$(vMarketFare2),$(vMarketFare3),$(vMarketFare4),$(vMarketFare5),$(vMarketFare6),$(vMarketFare7),$(vMarketFare8),

$(vMarketFare9),$(vMarketFare10),$(vMarketFare11),$(vMarketFare12),$(vMarketFare13),$(vMarketFare14),$(vMarketFare15),$(vMarketFare16),

$(vMarketFare17),$(vMarketFare18),$(vMarketFare19),$(vMarketFare20))

2)RangeMin(If($(vMKTFare1) = $(vMarketFare2), Null(), $(vMarketFare2)), If($(vMKTFare1) = $(vMarketFare3), Null(), $(vMarketFare3)), If($(vMKTFare1) = $(vMarketFare4), Null(), $(vMarketFare4)), If($(vMKTFare1) = $(vMarketFare5), Null(), $(vMarketFare5)),If($(vMKTFare1) = $(vMarketFare6), Null(), $(vMarketFare6)),

If($(vMKTFare1) = $(vMarketFare7), Null(), $(vMarketFare7)),If($(vMKTFare1) = $(vMarketFare8), Null(), $(vMarketFare8)),If($(vMKTFare1) = $(vMarketFare9), Null(), $(vMarketFare9)),

If($(vMKTFare1) = $(vMarketFare10), Null(), $(vMarketFare10)),If($(vMKTFare1) = $(vMarketFare11), Null(), $(vMarketFare11)),If($(vMKTFare1) = $(vMarketFare12), Null(), $(vMarketFare12)),

If($(vMKTFare1) = $(vMarketFare13), Null(), $(vMarketFare13)),If($(vMKTFare1) = $(vMarketFare14), Null(), $(vMarketFare14)),If($(vMKTFare1) = $(vMarketFare15), Null(), $(vMarketFare15)),

If($(vMKTFare1) = $(vMarketFare16), Null(), $(vMarketFare16)),If($(vMKTFare1) = $(vMarketFare17), Null(), $(vMarketFare17)),If($(vMKTFare1) = $(vMarketFare18), Null(), $(vMarketFare18)),

If($(vMKTFare1) = $(vMarketFare19), Null(), $(vMarketFare19)),If($(vMKTFare1) = $(vMarketFare20), Null(), $(vMarketFare20)))

3)RangeMin(

If($(vMarketFare1) = MKT1 OR $(vMarketFare1) = MKT2, Null(), $(vMarketFare1)),

If($(vMarketFare2) = MKT1 OR $(vMarketFare2) = MKT2, Null(), $(vMarketFare2)),

If($(vMarketFare3) = MKT1 OR $(vMarketFare3) = MKT2, Null(), $(vMarketFare3)),

If($(vMarketFare4)= MKT1 OR $(vMarketFare4) = MKT2, Null(), $(vMarketFare4)),

If($(vMarketFare5) = MKT1 OR $(vMarketFare5) = MKT2, Null(), $(vMarketFare5)),

If($(vMarketFare6) = MKT1 OR $(vMarketFare6)= MKT2, Null(), $(vMarketFare6)),

If($(vMarketFare7) = MKT1 OR $(vMarketFare7)= MKT2, Null(), $(vMarketFare7)),

If($(vMarketFare8) = MKT1 OR $(vMarketFare8)= MKT2, Null(), $(vMarketFare8)),

If($(vMarketFare9) = MKT1 OR $(vMarketFare9)= MKT2, Null(), $(vMarketFare9)),

If($(vMarketFare10) = MKT1 OR $(vMarketFare10)= MKT2, Null(), $(vMarketFare10)),

If($(vMarketFare11) = MKT1 OR $(vMarketFare11)= MKT2, Null(), $(vMarketFare11)),

If($(vMarketFare12) = MKT1 OR $(vMarketFare12)= MKT2, Null(), $(vMarketFare12)),

If($(vMarketFare13)=MKT1 OR $(vMarketFare13)= MKT2, Null(), $(vMarketFare13)),

If($(vMarketFare14) = MKT1 OR $(vMarketFare14)= MKT2, Null(), $(vMarketFare14)),

If($(vMarketFare15) = MKT1 OR $(vMarketFare15)= MKT2, Null(), $(vMarketFare15)),

If($(vMarketFare16) = MKT1 OR $(vMarketFare16)= MKT2, Null(), $(vMarketFare16)),

If($(vMarketFare17) = MKT1 OR $(vMarketFare17)= MKT2, Null(), $(vMarketFare17)),

If($(vMarketFare18) = MKT1 OR $(vMarketFare18)= MKT2, Null(), $(vMarketFare18)),

If($(vMarketFare19) = MKT1 OR $(vMarketFare19)= MKT2, Null(), $(vMarketFare19)),

If($(vMarketFare20) = MKT1 OR $(vMarketFare20)= MKT2, Null(), $(vMarketFare20))

)

Thanks,

Siva

Re: How to write set analysis

ekech_infomotio — Wed, 11 Jul 2012 10:30:33 GMT

Hi Siva,

I hope your whole application doesn't look like this three expressions - especially your first two expressions are very hard to read...

And perhaps you think about giving a little clue about your data(model) and the purpose of your expressions - perhaps someone will find a more elegant solution.

regards,

Edgar

Re: How to write set analysis

siva_boggarapu — Wed, 11 Jul 2012 11:02:37 GMT

Hello Edgar,

Thanks for your reply.

FYI

http://community.qlik.com/thread/56199

Thanks,

Siva

topic How to write set analysis in QlikView

How to write set analysis

Re: How to write set analysis

Re: How to write set analysis