Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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