topic Re: Alternate states issue in QlikView

Alternate states issue

sifatnabil — Mon, 24 Oct 2016 11:51:54 GMT

Hi all,

I have an alternate states expression that looks like this:

sum({PriorState<

MARKET_ID=$::MARKET_ID,

MFLAG=$::MFLAG

>}aggr(max(

{PriorState<

MARKET_ID=$::MARKET_ID,

MFLAG=$::MFLAG

TOTAL_AMOUNT),ORDER_ID))

With MARKET_ID, it works fine. But if I add MFLAG, the value becomes 0. I can add other fields and they work, but not MFLAG. I investigated MFLAG and don't see anything wrong with it. It only has 2 values, YES and NO. Any ideas why a single field could stop the expression from working?

Re: Alternate states issue

sifatnabil — Tue, 25 Oct 2016 07:12:43 GMT

bump..

Re: Alternate states issue

jonathandienst — Tue, 25 Oct 2016 07:36:05 GMT

I think you may need to provide a sample to illustrate your problem and to allow for diagnosis. My guess is that MFLAG is not properly associated with the other fields, or is misaligned, so selecting any MFLAG value deselects everything else. But that's just a guess.

Preparing examples for Upload - Reduction and Data Scrambling

Re: Alternate states issue

sifatnabil — Wed, 26 Oct 2016 08:52:01 GMT

Thanks jontydkpi‌, very useful link. I found the issue was with null values in the fields. After replacing all null values with "N/A", it worked again. Is it common knowledge that alternate states cannot work with null values?

Re: Alternate states issue

sunny_talwar — Wed, 26 Oct 2016 10:33:17 GMT

Is it common knowledge that alternate states cannot work with null values?

I have never heard of this before. I think in general null values are kind of a headache to handle within set analysis. But AFAIK, and I may be I am wrong, I don't think that it has anything to do with the use of alternate state.

Re: Alternate states issue

sifatnabil — Wed, 26 Oct 2016 10:35:26 GMT

I think it matters when you try to retrieve the values from another state, i.e. MFLAG=$::MFLAG - if there are nulls, it behaves strangely. Removing nulls fixed this for me.

Re: Alternate states issue

sunny_talwar — Wed, 26 Oct 2016 10:39:05 GMT

Would you be able to share a small sample where we might be able to see this issue?