Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

comparative analysis (bug?)

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

I can walk on water when it freezes
2 Replies
datanibbler
Champion
Champion

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

ali_hijazi
Partner - Master II
Partner - Master II
Author

is it because QC_Theme is null for some records?

I can walk on water when it freezes