Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
srinivasa1
Creator II
Creator II

Set Analysis

Hi 

I know I’m making mistake in SetAnalysis not able to figure out how to achieve this

I need to change font color of text object dynamically  based on List box CalcValue selection ie: if selected 7 from calcValue list box its falls under (Low Value 1 and HighValue 10) in that case need to set textObject calculated font color as RGB(255,0,0) same way if calc value changes color code must change based on low and high val color.

below is script and i have attached dummy application

=MaxString({$<ID={'$(=$(v_ID))'},Key={'$(=$(v_Key))'}, type={$(v_Type)}, LowVal={"<=$(v_calcVal)"}, HighVal={">=$(v_calcVal)"}Color)

Highly appreciate help on this

4 Replies
srinivasa1
Creator II
Creator II
Author

Hi

Is any guidence?

Thanks

MayilVahanan

Hi

Try like this

=MaxString({$<ID={'$(=$(v_ID))'}, type={'$(=$(v_Type))'}, LowVal={"<=$(=$(v_calcVal))"}, HighVal={">=$(=$(v_calcVal))"}>}Color)

Have doubt, calcValue is not link with any field just using for calculation purpose, then why you can't use input box instead of list box?

v_key is always specific women only?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
srinivasa1
Creator II
Creator II
Author

Thanks For your replay.

your right calcValue is not link with any field just using for calculation purpose.i need use like this only

v_key is always specific not women it also foe man based on add type form button


still my font color not get change i need use setanalysis as caluclated color

Thanks

giakoum
Partner - Master II
Partner - Master II

Please see attached.

Changes :

1. Variables needed = sign

2. Set analysis had wrong syntax

3. 3 new columns in excel for R, G, B

4. By using GetSelections you need to select something in those fields in order to get a result