topic comparative analysis (bug?) in QlikView

comparative analysis (bug?)

ali_hijazi — Tue, 07 Apr 2015 09:47:52 GMT

Hello

I'm using comparative analysis and thus created an alternate state called Group 1

my expression as as follows:

sum({[Group 1]<QC_THEME=$::QC_THEME, STEP_DURATION_MIN={'>0'},RECORD_TYPE={'duration'},TPK=$::TPK,STEP_PHASE=$::STEP_PHASE,JOB_ID=$::JOB_ID>}STEP_DURATION_MIN)

now it gives null but if I remove QC_THEME=$::QC_THEME it gives the correct value

please advise

Re: comparative analysis (bug?)

datanibbler — Tue, 07 Apr 2015 09:57:50 GMT

Hi Ali,

maybe because you have an expression like A<B=C in your set_expression? Does that work when you test it in a textbox or so? I don't really understand what that >> $:: << means, but in my experience, expressions with two operators are always tricky. Can you pull that apart into two expressions?

HTH

Re: comparative analysis (bug?)

ali_hijazi — Tue, 07 Apr 2015 10:00:44 GMT

is it because QC_Theme is null for some records?